Devart Forums

/*
--SQL 2000 or SQL 2005 or SQL 2008
Create table test
(
column1 numeric(14,4)
)
insert into test values(14.55)
*/
TMemoryStream *ms=new TMemoryStream();
ADOQuery1->SQL->Add("select * from test");
ADOQuery1->Open();
VirtualTable1->Assign(ADOQuery1);
VirtualTable1->SaveToStream(ms); <---Unknown data type FieldDesc.DataType=27


//I Use VirtualTable 6.90 for RAD Studio 2010

My English is not very good, but others do not have this problem?
I am now using C + + Builder, where has also tried in Delphi, but also have this problem.

Try to save data to XML format using the SaveToXML method. This format supports more data types.

Sorry, I think this method does not provide TVirtualTable

TVirtualTable have the SaveToXML method.

I am sorry, I am wrong, there is this method, but this method to generate the XML file, VirtualTable not re-loaded, loading tips: Data type is not supported.

Sorry, not this field, and is a Guid, SQL Server in NewID (), XML for type = 'uuid'

In addition, VirtualTable1-> Assign (ADOQuery1); often 'Out of Memory'

System: Windows2003 3G Memory