mySql and bigint ID

[bg2003]

When fetching data from a MySQL table using a simple SQL query "select * from" all of the data is returned properly except for the ID column. The ID column is a primary key set to auto incremental, bigint type. 

Labview returns no values. Is there some limitation. Thanks. 

LV2012, MySQL 5.2

[thoult]

If you're using VIs from the Database palette in Connectivity, you should return variant data from the database. For a column whose datatype is bigint, Variant to Data wired with a numeric constant set to I64 should work.

[bg2003]

Thanks. That works.