Try
INSERT INTO ('"School ID"', 'Name')
VALUES('22222', 'TEST')
ymmv
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
