Recent

Author Topic: SQL on Interbase - error when use : in a string  (Read 5514 times)

filipenf

  • New member
  • *
  • Posts: 5
SQL on Interbase - error when use : in a string
« on: September 16, 2005, 02:57:03 pm »
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

  • Guest
RE: SQL on Interbase - error when use : in a string
« Reply #1 on: September 19, 2005, 10:35:28 am »
Yes, I have this error in Windows XP,
Lazarus team: please do something

Vincent Snijders

  • Administrator
  • Hero Member
  • *
  • Posts: 2661
    • My Lazarus wiki user page
RE: SQL on Interbase - error when use : in a string
« Reply #2 on: September 19, 2005, 10:54:30 am »
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

  • New member
  • *
  • Posts: 5
RE: SQL on Interbase - error when use : in a string
« Reply #3 on: September 19, 2005, 12:58:03 pm »
OK, I'll do that...

Thanks

Marcin Misiak

  • Guest
Re: RE: SQL on Interbase - error when use : in a string
« Reply #4 on: October 28, 2005, 08:14:44 pm »
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 :(((((