Hello everybody.

-
Hello everybody.
Is someone here who Can help me with Delphi and sqlite?
I have a Memo field with lots of Text but I cannot get it to work with any field Type.
I get an Error that there is no converter.

Thanks in advance
Frank

Comments

  1. Maciej WierzbowskiSeptember 28, 2016 at 11:22 AM

    Please show a part of your code how do you read the database.

    ReplyDelete
  2. Frank DuchnaSeptember 28, 2016 at 11:49 AM

    Maciej Wierzbowski​ I use a "select * from table1" to retrieve the data into a clientdataset. From there it goes straight into a datasource and the Single Fields are then Link with livebindings to different Controls. One control is a Memo. If needed I could Post the create Database scripts here. Just let me know.

    ReplyDelete
  3. Богдан ЛевицкийSeptember 28, 2016 at 1:07 PM

    Try to use yourmemo.text := YourField.AsMemo or AsText. Otherwise you should manualy read blob into tstream and then load it to tmemo using Something like Tblobfield(yourblobfield).savetostream(yourstream). Then yourstream.position:=0; memo.loadfromstream(yourstream). Dont forget yourstream := tmemorystream.create and yourstream.free ;)

    ReplyDelete
  4. Frank DuchnaSeptember 28, 2016 at 8:46 PM

    Hey Guys, in combination with another Problem i had with a locked database at startup i had to Change locking Mode to normal. Now it all works.
    Thanks for all the help.

    ReplyDelete

Post a Comment