ADO/SQL-Server LoadFromFile (XML)
From: Víctor Hugo Ulloa Meléndez (tfertil_at_hotmail.com)
Date: 02/23/04
- Next message: Sascha Schroeder: "Re: Parameters with same name in one query"
- Previous message: Mike Walsh: "Re: Parameters with same name in one query"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 23 Feb 2004 09:20:56 -0600
Hi everyone,
We're using Delphi 7, SQL-Server 2000 SP3, Windows XP and ADO
connections and datasets.
We're trying to load data into a SQL table from an XML file. The XML
is generated in a remote site using:
MyAdoDataset.SaveToFile('filename.xml',fgXML);
When our site gets the file and try a
MyAdoDataSet.LoadFromFile('filename.xml');
we got no exceptions, and a dbGrid connected to the dataset loaded on
screen shows the data loaded from the file. But when we close
MyAdoDataSet and inspects the table on the SQL-Server, it's empty!!
Details to take note:
A. The original table on remote site has a different name than the
target table at our site (but the same structure).
What are we missing? Thanks to all,
Víctor H. Ulloa
Tierra Fertil S.A.
- Next message: Sascha Schroeder: "Re: Parameters with same name in one query"
- Previous message: Mike Walsh: "Re: Parameters with same name in one query"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
