Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

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
0
Hornwood
Asked:
Hornwood
  • 2
  • 2
1 Solution
 
rinfoCommented:
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.
0
 
HornwoodAuthor Commented:
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
0
 
rinfoCommented:
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.
0
 
HornwoodAuthor Commented:
Problem is with the SQLite3 and Tdataset provider in delphi (20 character limit : googled) - wrote a work around
0
Question has a verified solution.

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

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now