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