SQL on Interbase - error when use : in a string

[filipenf]

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]

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

[Vincent Snijders]

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]

OK, I'll do that...

Thanks

[Marcin Misiak]

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 ((((