[DUG] SQL - INSERT

[Rohit Gupta]

John, to avoid future unforseen problems, you should remove the 
space.  We use underscore for our table and field names and alias 
them in queries for more user friendly names as required.

From:           	"John" <john at padasy.co.nz>
To:             	"DUG" <delphi at ns3.123.co.nz>
Date sent:      	Thu, 1 Sep 2005 13:15:05 +1200
Subject:        	[DUG] SQL - INSERT
Send reply to:  	john at padasy.co.nz,
       	NZ Borland Developers Group - Delphi List <delphi at ns3.123.co.nz>
	<mailto:delphi-request at ns3.123.co.nz?subject=unsubscribe>
	<mailto:delphi-request at ns3.123.co.nz?subject=subscribe>

[ Double-click this line for list subscription options ] 

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
Regards

Rohit

======================================================================
CFL - Computer Fanatics Ltd.  21 Barry's Point Road, AKL, New Zealand
PH    (649) 489-2280 
FX    (649) 489-2290
email rohit at cfl.co.nz  or  r.gupta at xtra.co.nz
======================================================================