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
Easy For Beginner Student For Me