Delphi SQLITE3 TDataprovider truncating strings

I have a delphi application utilising SQLite3 as a database. My problem is that when I use the dataprovider with the TClientDataset to pass the queried data to RAVE Reports the strings are all fine for the first 20 characters then after that they are a mixture of ??? and other characters. Any help would be appreciated.

Thanks

Hornwood

Asked: 2012-03-29

Advertise Here

1 Solution

LVL 9

rinfoCommented: 2012-03-30

Can you post data field structure.
Alternately try and display this string value in a message box to know whether it it being displayed properly
Seems more a like a problem with rave report.

HornwoodAuthor Commented: 2012-03-30

I have displayed in a text box directly from the SQL and it is definetly a issue with SQLite3 and dataprovider and Tclientdataset controls as running through normal query componets the data is fine but i need to submit via a dataset to RAVE and its here that the issue is.

Works fine up to 20 characters

LVL 9

rinfoCommented: 2012-03-30

You should have posted field structure for the mentioned field .
If the textbox is displaying field value like rave reports that has certainly got something to
do with sqlite or its data provider.
Have you manually checked the value in a sqlite data manager where you can view the value
There is also a command line utility 'sqlite.exe' which allows you to query on sqlite database.
Please check the values in table.

HornwoodAuthor Commented: 2012-04-20

Problem is with the SQLite3 and Tdataset provider in delphi (20 character limit : googled) - wrote a work around

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

Delphi SQLITE3 TDataprovider truncating strings

Join & Write a Comment Already a member? Login.

Featured Post