asstring Truncating left most character in field.

johnbitner · Post by **johnbitner** » Fri 23 Oct 2009 20:15

I have an issue with the Unidac 3.00.0.3. I attaching to a access 2007 database and when I use table.fieldbyname('fieldname').asstring; some of the fields in the database have the left most character truncated. not all fields just 1 column.

For example: In msaccess i see "Here is the dog" on screen in the dbgrid i see "ere is the dog" The H is missing.

I have no idea what would cause this but I have a sample app and database that recreates this problem that I can send.

Plash · Post by **Plash** » Mon 26 Oct 2009 09:07

There is the problem with Memo fields. We'll fix it in the next UniDAC build.

If you have a Memo field in SELECT statement, all fields that come after Memo can be fetched incorrectly.

johnbitner · Post by **johnbitner** » Mon 26 Oct 2009 12:20

This is what most would consider to be a basic functionality failure. How did this issue slip through while testing? If I shipped my software products like this to hundreds of customers I would loose 100's of customers overnight.

Using the UniDAC lib is making me a little nervous since users are finding more and more issues every week with regards to access support.

These basic failures should be patched and released as soon as they are found. Patched like this cannot go for a month or more between releases.