?
Solved

Delphi SQLITE3 TDataprovider truncating strings

Posted on 2012-03-29
4
Medium Priority
?
535 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Six Sigma Control Plans

800 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