Unknown data type FieldDesc.DataType=27

Unknown data type FieldDesc.DataType=27

Postby 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
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Postby 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.
wg961423
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Postby Plash » Thu 14 Jan 2010 08:58

Try to save data to XML format using the SaveToXML method. This format supports more data types.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby wg961423 » Fri 15 Jan 2010 02:36

Sorry, I think this method does not provide TVirtualTable
wg961423
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Postby Plash » Fri 15 Jan 2010 12:32

TVirtualTable have the SaveToXML method.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Postby wg961423 » Tue 26 Jan 2010 07:38

Sorry, not this field, and is a Guid, SQL Server in NewID (), XML for type = 'uuid'
wg961423
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Postby wg961423 » Tue 26 Jan 2010 07:44

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

System: Windows2003 3G Memory
wg961423
 
Posts: 6
Joined: Fri 23 Oct 2009 06:02


Return to VirtualDAC