Unidac Microsoft Access TMemoField is Truncating

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bob
Posts: 10
Joined: Thu 03 Jan 2008 21:18

Unidac Microsoft Access TMemoField is Truncating

Post by Bob » Thu 15 Apr 2010 14:41

I am converting from using the TAdoquery component using a Microsoft Access database to the Tuniquery component.

I use to be able to do the following.

var query : Tadoquery;

begin
...
slist := TStringlist.create;
try
//script is of type TMemoField
slist.text := query.fieldbyname('script').asstring;
//slist would now contain the full contents - works great
finally
slist.free;
end;
end;

Now with TUniquery...

var query : Tuniquery;
begin
...
slist := TStringlist.create;
try
//script is of type TMemoField
slist.text := query.fieldbyname('script').asstring;
//slist contents are now truncated.
finally
slist.free;
end;
end;

I have already tried many things to get the full contents from the script field with no success.

What am I doing wrong?

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Fri 16 Apr 2010 12:54

Hello

Please send us full content of your "script" memo field and content truncated by the TUniQuery component and we will help you to resolve the issue.

Bob
Posts: 10
Joined: Thu 03 Jan 2008 21:18

Sample Project

Post by Bob » Fri 16 Apr 2010 13:52

I have posted a sample project for download at http://www.tiermed.com/TEST/test.zip

There are 2 buttons. One uses TAdoquery which works and the other uses TUniQuery which does not work.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Mon 19 Apr 2010 10:09

I am trying to download your example and I am getting an error: "You are not authorized to view this page". Link "http://www.tiermed.com/TEST/test.zip" is not available for me.

Please share this example again at any available server or send this example to us by E-mail.

Bob
Posts: 10
Joined: Thu 03 Jan 2008 21:18

Posted by email

Post by Bob » Mon 19 Apr 2010 13:43

I am trying to figure out at our end why it is blocked, however I also sent by email attachment.

Bob
Posts: 10
Joined: Thu 03 Jan 2008 21:18

Update to fix

Post by Bob » Tue 11 May 2010 13:34

I know that you have fixed this, and am waiting patiently for the fix. I even reverted back to using ADO so that I can release my product. When is your next release going to be?

My work around did not work in all cases - so I had to give up on it.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Wed 12 May 2010 12:16

Hello

We are going to release the new build next week.

Post Reply