1 (edited by prahousefamily 2016-12-09 07:53:34)

Topic: How To Export & Import XML Insert Database

From Function

DataSetToXML(,)

i try use this function for Type longText,long Blob in database than  function  export text 
because header column not in function export text

Step 1
Export select all data in table A to XML OK. Pass

Var
DT :TdataSet;
begin
SQLQuery('SELECT * FROM A',DT);
DeleteFile(ExtractFilePath(Application.ExeName)+'Script\A.xml');
DataSetToXML(DT,ExtractFilePath(Application.ExeName)+'Script\A.xml') ;
ShowMessage('OK Step 1 Pass');
end;

Step 2
Delete All data And update Table A OK. Pass

begin
SQLExecute('DELETE FROM A ;');
UpdateDatabase('A');
ShowMessage('OK Step 2 Pass');
end;

Step 3 ???????
How to Import XML Insert Database ?????
Help ME please

Post's attachments

Attachment icon Advance DataseXML.zip 4.39 kb, 523 downloads since 2016-12-09 

My Visual Database : I Love You
Easy For Beginner Student For Me

Re: How To Export & Import XML Insert Database

Import from XML is not support.

Dmitry.