[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Delphi SQLITE3 TDataprovider truncating strings

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Six Sigma Control Plans
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

656 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