[Database toolkit] possibility to Load From xml File into Labview then into database

[Altran_Ace]

Before writing into my database, I want to save it and reload it if the user want to cancel the new load that can last several minute.

If he cancel the load I load my previous database data.

I succeed to save my database data into xml file thanks to the VI 'DB Tools SaveRecordSet To File'. This VI saves directly the contains of my database table into xml file. And finally, I just though the other VI to load it from file will do the same, means load the file and save it into my database but finally it just give a recordset into labview.

Question : is there any simple possibility to load the xml file into the database directly through Labview ?

why, finally, these two VIs don't have the same behaviour ?

[Thomas_robertson · Accepted solution]

I don't know, but I just thought I'd chime in, that if you fail to do it with LabvIEW, you might want to look into doing your writing as a database "Transaction", if your DBM supports that (most except MS Access will)

[Altran_Ace]

Thks Thomas, I used the VI transaction for begin and commit or rollback at the end following the cancel button. It seems to work .

[Wiebe@CARYA]

"Thomas robertson" <x@no.email> wrote in message
news:1225897808035-803979@exchange.ni.com...
> I don't know, but I just thought I'd chime in, that if you fail to do it
with LabvIEW, you might want to look into doing your writing as a database
&quot;Transaction&quot;, if your DBM supports that (most except MS Access
will)

Wow, this notion was very usefull for me. I didn't know about the
"Transaction" thing at all. I am using the LabSQL toolkit, and since I get
access to all ADO methods, this is easy to implement. It is exactly what I
need for a current project.

I tried it with MS Access, and it works just fine. Why shouldn't it work?

Regards,

Wiebe.

[Thomas_robertson]

I didn't realize that MS Access has transaction support... Even better!  In that case, maybe I'll use it in my project (I was avoiding it because our software aims to support Oracle, SQL Server, MySQL, and Access)

[Wiebe@CARYA]

"Thomas robertson" <x@no.email> wrote in message
news:1226068815596-805488@exchange.ni.com...
> (I was avoiding it because our software aims to support Oracle, SQL
Server, MySQL, and Access)

Yes, so it does support Access?

Anyway, please try it yourself instead of trusting my primitive tests,
before changing your entire project! Please do let know your results...

Regards,

Wiebe.