Forum > Databases

SQL on Interbase - error when use : in a string

(1/1)

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

Navigation

[0] Message Index