Page 1 of 1

Quoting Error?

Posted: 18.03.2008, 13:17
by jascha
I have a simple TZQuery connected to a sqlite3 db.
The query is "SELECT * FROM page"

Now I want to save the data from a RichEdit into the db:

zqPage.Edit;
zqPage.FieldByName('page_text').AsString:=frmrichedit1.RTFText;
zqPage.Post;

When I execute this I get a EZSQLException. I think its because of the special chars in the RTF Code.

Is this a Bug?

Posted: 22.03.2008, 12:24
by mdaems
Please,

Try to add a TZSQLMonitor to your application to check what query is sent to the database exactly.

There may be something wrong with the special characters. Other possible reasons may be special column names which need escaping, ...

Mark