How can I retrieve the col data size and Null information from table using labview connectivity toolset

[lvvl]

Hi, there,
I am wondering how to get the table information by labview database
connectivity toolset. The table list vi comes with the toolset can get
only col name, data type and data size. And I found the the data size
always gives back -1, even though it is a string type. Do somebody has
some idea about it?
Thanks.
JJ

[Crystal]

JJ,

Go into the diagrams of the DBTools List Columns and DBTools Get Properties respectively. When you inspect this diagram, you will see the raw ActiveX properties and methods called to get the size information. The value of -1 means the requested recordset is already closed. This is the sort of thing that is controled by the driver (ODBC, OLE DB, Jet, etc) you are using. Notice that you can right click on the property and invoke nodes and get more information about these specific items directly from the ADO online help.

Crystal