|
weirdave
Starting Member
USA
6 Posts |
 Posted - 03 August 2001 : 11:57:07
|
I received the following errors which it said to post:
Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int COUNTER NOT NULL , G_NAME VARCHAR (50) NOT NULL , G_EMAIL VARCHAR (100) NOT NULL , G_WEBSITE VARCHAR (100) NULL , G_ICQ VARCHAR (30) NULL , G_MESSAGE memo NOT NULL , G_DATE VARCHAR (50) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int COUNTER NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL , G_V1_SWITCH INT NOT NULL , G_V2_SWITCH INT NOT NULL , G_V3_SWITCH INT NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_VARFIELD1, G_VARFIELD2, G_VARFIELD3) VALUES (0, 0, 0, 'ab', 'ab', 'ab')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_GB_OPTIONS'.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE memo NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
|
|
Topic Locked
