[DUG] SQL - INSERT

[Trevor Jones]

Try

INSERT INTO ('"School ID"', 'Name')
VALUES('22222', 'TEST')

ymmv
 
-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of John
Sent: Thursday, 1 September 2005 1:15 p.m.
To: DUG
Subject: [DUG] SQL - INSERT

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

_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi