strings using SQL

[johndelphi]

i have this code:
q.SQL.Add('SELECT * FROM GroupItem WHERE ID = "' + userID + '"');
where userID is obviously a string.
I get an error with it and i think its the whole string within a string problem.
how do i typecast the string for the SQL statement to read the userID.

 

[Zathras]

Not all DBMS accept the double quote as a string delimiter. Try this:
[blue]

q.SQL.Add('SELECT * FROM GroupItem WHERE ID = ' + QuotedStr(userID));

[/color]