[yunqa.de] Re: TDISQLite3UniDirQuery select * thinks string field is ftFloat

  • From: Ann Lynnworth <ann@xxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Wed, 11 Jul 2012 04:19:23 +0000

The structure of the database is outside my control. It is fixed. Is there something I can do to compensate for the wrong structure?


Why is SQLiteSpy able to display the dataset without trouble?

That URL fails to load right now.


On 07/10/2012 11:04 AM, Radovan Antloga wrote:
You have declared fields as STRING.
You should declare it as TEXT.
Look at this article:

http://www.sqlite.org/datatype3.html#affinity

Regards
R.Antloga

_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa



Other related posts: