SQL on Interbase - error when use : in a string
lazarus / 16-Databases

----------------------------------------------------------------------
filipenf · 2005-09-16 12:57

I've made a library and compiled it in both windows and linux
platforms.
On windows all is working OK, but on linux a strange error happens.
When any string on SQL has a :, I get the following error: "Unexpected
end of command".
The SQL is like this:
INSERT INTO TABLE(FIELD1,FIELD2,FIELD3)
VALUES ('FIELD1', 'FIELD2', ' FIELD: 3');

If I remove the : the SQL is executed successfully. The server is the
same when I run linux or windows library. This error is getting me
crazy. :cry:

I'm using Lazarus 0.9.8 with FPC 2.0 and on Windows Lazarus 0.9.8

Thanks for any help...

----------------------------------------------------------------------
Anonymous · 2005-09-19 08:35

Yes, I have this error in Windows XP,
Lazarus team: please do something

----------------------------------------------------------------------
Vincent Snijders · 2005-09-19 08:54

Since this is DB-related and the DB is part of the FCL, you can submit
a bug report at the FPC bug tracker.

----------------------------------------------------------------------
filipenf · 2005-09-19 10:58

OK, I'll do that...

Thanks

----------------------------------------------------------------------
Marcin Misiak · 2005-10-28 18:14

thers anather resolusion in yuo wont add 1 record:

use dbedit and dbnavigator
and button "OK" with this code:
SQLquery1.ApplyUpdates;

and when you close applications don't forget commit transaction.

ps
There's no describle in  wiki doc lazarus ((((