Create Table problem (database)

[krappleby025]

Hi all,

Im using the following command to create a table in a MS SQL version 7 database

con.execute("CREATE TABLE memberoffers (memoffid mediumint( 10 ) NOT NULL default '0',offerid mediumint( 10 ) NOT NULL default '0',memberid varchar( 200 ) NOT NULL default '',amount varchar( 50 ) NOT NULL default '',date varchar( 14 ) default NULL ,paid varchar( 10 ) NOT NULL default '',open varchar( 10 ) NOT NULL default 'YES',duration varchar( 10 ) NOT NULL default '') TYPE = MyISAM ;&quot

But its comming back with the following error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'open'.

/databasesetup.asp, line 3

any ideas what is wrong...

Thanks

 

[Digimon02]

try to enclose the field name open with bracket. open is reserved word in SQL Server..

 

[mwolf00]

date is also reserved...

con.execute("CREATE TABLE memberoffers (memoffid mediumint( 10 ) NOT NULL default '0',offerid mediumint( 10 ) NOT NULL default '0',memberid varchar( 200 ) NOT NULL default '',amount varchar( 50 ) NOT NULL default '',[date] varchar( 14 ) default NULL ,paid varchar( 10 ) NOT NULL default '',[open] varchar( 10 ) NOT NULL default 'YES',duration varchar( 10 ) NOT NULL default '') TYPE = MyISAM ;&quot

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook