[DUG] SQL - INSERT

[Dennis Chuah]

Use double quotes for your field name and you also need the name of the 
table you are inserting into.

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


----- Original Message ----- 
From: "John" <john at padasy.co.nz>
To: "DUG" <delphi at ns3.123.co.nz>
Sent: Thursday, September 01, 2005 1:15 PM
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
>