Solved

Delphi SQLITE3 TDataprovider truncating strings

Posted on 2012-03-29
4
523 Views
Last Modified: 2012-04-20
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
Comment
Question by:Hornwood
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:rinfo
ID: 37786459
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
 

Accepted Solution

by:
Hornwood earned 0 total points
ID: 37786554
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
 
LVL 9

Expert Comment

by:rinfo
ID: 37786617
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
 

Author Closing Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question