Unknown data type FieldDesc.DataType=27

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wg961423
Posts: 6
Joined: Fri 23 Oct 2009 06:02

Unknown data type FieldDesc.DataType=27

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

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
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

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

Post by wg961423 » Fri 15 Jan 2010 02:36

Sorry, I think this method does not provide TVirtualTable

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 15 Jan 2010 12:32

TVirtualTable have the SaveToXML method.

wg961423
Posts: 6
Joined: Fri 23 Oct 2009 06:02

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

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

Post by wg961423 » Tue 26 Jan 2010 07:44

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

System: Windows2003 3G Memory

Post Reply