I have my application compiled in Delphi 7 using MyDAC. When I export the database to XML, with something like:
Code: Select all
procedure TableToXML(XMLFileName: String);
var
TempQuery: TMyQuery;
begin
Database_CreateQuery(TempQuery);
with TempQuery do
begin
Options.EnableBoolean := False;
SQL.Clear;
SQL.Add(Format('SELECT * FROM %s', [TB_CUSTOMERS]));
Open;
TempQuery.SaveToXML(XMLFileName);
Free;
end;
end;
Code: Select all
...
<rs:data>
<z:row ID_Order='1' info='T<0x00>e<0x00>s<0x00>t<0x00>'
...
...
The problem is when I compile my application for Delphi Rad Studio 10.x and import the XML. The "<0x00>" is recognised as a NULL terminated string and I just get "T" from the above example.
When I use the same code on Delphi 10.x and export to XML, the result is:
Code: Select all
...
<rs:data>
<z:row ID_Order='1' info='Test'
...
...
I want to reuse my old database (exported in XML from Delphi 7) with my new application (compiled with Delphi 10.x)
Thanks!