Page 1 of 1

UniQuery or UniTable returning only first 40 characters from DB Field

Posted: Mon 18 Nov 2013 15:29
by ninadgac
I am using UniTable & UniQuery to extract data from database. At my DB Table there is one field/column named as Description which contains string data type. But when I extracted data from Database table using UniQuery or UniTable it is returning only first 40 characters from Description field.

I also checked the fact using following code

Code: Select all

 
  UniQuery1.First;
  while Not UniQuery1.Eof do
  begin
    if Length(UniQuery1.FieldByName('description').AsString) > 40 then
       ShowMessage(UniQuery1.FieldByName('description').AsString);
    UniQuery1.Next;
  end;
Any solution to this problem? What should be missing ?

Re: UniQuery or UniTable returning only first 40 characters from DB Field

Posted: Mon 18 Nov 2013 16:05
by AndreyZ
Please specify the provider (TUniConnection.ProviderName) you are working with.

Re: UniQuery or UniTable returning only first 40 characters from DB Field

Posted: Mon 18 Nov 2013 17:59
by ninadgac
UniProvider name was SQLiteUniProvider. I am using SQLite DB.

Problem sorted out, in DB table description field was declared as

description varchar ( 40 )

edited it as

description varchar ( 200 ) or greater.

Re: UniQuery or UniTable returning only first 40 characters from DB Field

Posted: Tue 19 Nov 2013 06:48
by AndreyZ
It is good to see that this problem has been solved. Feel free to contact us if you have any further questions about UniDAC.