MS Access Text(1) data type
Posted: Thu 06 Feb 2014 14:27
We have a ms access table in following format.
CREATE TABLE TestTable ([f1] long,[f2] text(200),[f3] long,[f4] text(1),[f5] text(1),[f6] text(1),[f7] text(1),[f8] text(4),[f9] text(1),[f10]text(1),[f11] text(1))
I has 300 rows and data in all the columns.
But when I use TuniConnection & TUniQuery , I only get data in first 4 columns.
I think uniQuery is not able to handle fields of type text(1) properly. It is able to show the first field of type text(1). There after its not showing data for columns of any data type.
Please advice.
Thank you.
CREATE TABLE TestTable ([f1] long,[f2] text(200),[f3] long,[f4] text(1),[f5] text(1),[f6] text(1),[f7] text(1),[f8] text(4),[f9] text(1),[f10]text(1),[f11] text(1))
I has 300 rows and data in all the columns.
But when I use TuniConnection & TUniQuery , I only get data in first 4 columns.
I think uniQuery is not able to handle fields of type text(1) properly. It is able to show the first field of type text(1). There after its not showing data for columns of any data type.
Please advice.
Thank you.