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" <[EMAIL PROTECTED]> To: "DUG" <[email protected]> Date sent: Thu, 1 Sep 2005 13:15:05 +1200 Subject: [DUG] SQL - INSERT Send reply to: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi List <[email protected]> <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> [ 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 [email protected] 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 [EMAIL PROTECTED] or [EMAIL PROTECTED] ====================================================================== _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
