[DUG] SQL - INSERT

John john at padasy.co.nz
Thu Sep 1 13:15:05 NZST 2005


Hi folks
 
Assume I have a table with a field name including a space character (e.g.
"School ID"). 
 
How can I specify an INSERT query, as the query listed below fails due to
the space character in the field name!
 
 
INSERT INTO ('School ID', 'Name')
VALUES('22222', 'TEST')
 
 
Regards
John



More information about the Delphi mailing list