Page 1 of 1

MS Access Text(1) data type

Posted: Thu 06 Feb 2014 14:27
by arusoft
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.

Re: MS Access Text(1) data type

Posted: Thu 06 Feb 2014 15:22
by AlexP
Hello,

We cannot reproduce the problem - data from your table is displayed in all the columns. Please try to reproduce the problem on the latest UniDAC version 5.2.5

Re: MS Access Text(1) data type

Posted: Fri 07 Feb 2014 21:17
by arusoft
Thanks for the update.I will update & let you know. But right now we are using 4.6.11.

Regards.

Re: MS Access Text(1) data type

Posted: Mon 10 Feb 2014 11:43
by AlexP
Yes, indeed, this problem is reproduced in old UniDAC versions, however, in the latest UniDAC version 5.2.5, data is displayed correctly in all the fields.

Re: MS Access Text(1) data type

Posted: Thu 13 Feb 2014 22:19
by arusoft
Looks like we need to buy upgrade to get latest version. We are in process of doing that. Will update once I test again with latest version.

Re: MS Access Text(1) data type

Posted: Fri 14 Feb 2014 12:07
by AlexP
If you encounter any issues with the latest UniDAC version, please contact us again.

Re: MS Access Text(1) data type

Posted: Sat 22 Feb 2014 18:51
by arusoft
So we upgraded to latest uniDac and this is looking much better.

Thank You.

Re: MS Access Text(1) data type

Posted: Mon 24 Feb 2014 11:03
by AlexP
You are welcome. Feel free to contact us if you have any further questions about UniDAC.