UniQuery or UniTable returning only first 40 characters from DB Field

[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 ?

[AndreyZ]

Please specify the provider (TUniConnection.ProviderName) you are working with.

[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.

[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.