Unknown data type FieldDesc.DataType=27

wg961423 · Post by **wg961423** » Mon 11 Jan 2010 03:45

/*
--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

wg961423 · Post by **wg961423** » Thu 14 Jan 2010 01:42

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.

Plash · Post by **Plash** » Thu 14 Jan 2010 08:58

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

wg961423 · Post by **wg961423** » Fri 15 Jan 2010 02:36

Sorry, I think this method does not provide TVirtualTable

Plash · Post by **Plash** » Fri 15 Jan 2010 12:32

TVirtualTable have the SaveToXML method.

wg961423 · Post by **wg961423** » Tue 26 Jan 2010 05:25

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.

wg961423 · Post by **wg961423** » Tue 26 Jan 2010 07:38

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

wg961423 · Post by **wg961423** » Tue 26 Jan 2010 07:44

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

System: Windows2003 3G Memory