Devart Forums

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

To solve the problem use single quotes instead of double, like this:

Thank you!!! Now, it works fine...