Actually, I'm converting a BDE application to a program using firebird server. I have a table DBUSERS with two data fields: USERNO AND USERNAME, I use a TIBCQuery:
with IBCQuery1 do begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM dbusers WHERE username LIKE "A%"');
Open;
end;
The result is the following error:
Dynamic SQL Error
SQL error code; -206
Column unknown
A%
At line 1, column 38
What is the correct syntax for string operations???
TIBCQuery: SQL syntax???
To solve the problem use single quotes instead of double, like this:
Code: Select all
SQL.Add('SELECT * FROM dbusers WHERE username LIKE ''A%'' ');