Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Delphi SQLITE3 TDataprovider truncating strings

Posted on 2012-03-29
4
Medium Priority
?
567 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Six Sigma Control Plans
Introduction to Processes

571 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