Re: ADO/SQL-Server LoadFromFile (XML)
From: Arthur Hoornweg (arthur.hoornweg_at_wanadoo.nl.net)
Date: 06/10/04
- Previous message: Arthur Hoornweg: "Re: Share one DATA MODULE between multipul dll's"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 10 Jun 2004 15:56:53 +0200
Víctor Hugo Ulloa Meléndez wrote:
> But when we close
> MyAdoDataSet and inspects the table on the SQL-Server, it's empty!!
Victor,
the "loadfromfile" only loads the XML file into the ADO cursor
engine in memory, it doesn't upload it to the server.
If you want to upload the data to the SQL database, you must
first set the tadoconnection.connectionobject in order to
connect it to the database, and subsequently issue a
"tadodataset.Updatebatch". Problem is, this will only upload the
*changes* made to the dataset while it was offline, not the whole
dataset. So this may not really help you!
They call this the "briefcase model":
- Load data from a server into a dataset
- Disconnect the dataset from the server,
- Make modifications to the dataset
- then save it into a XML file
- later, load the xml file into a dataset again
- re-connect the dataset to the server
- perform "updatebatch" to upload the modifications to the server.
-- Arthur Hoornweg (please remove the ".net" from my e-mail address)
- Previous message: Arthur Hoornweg: "Re: Share one DATA MODULE between multipul dll's"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
