| Author |
 Topic  |
|
|
mb
Starting Member
9 Posts |
 Posted - 26 April 2001 : 09:03:25
|
What is wrong by the sql statement
Adding Column...
File Attachment Mod
Creating table(s)...
CREATE TABLE FORUM_USERFILES( F_FILEID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , MEMBER_ID int NOT NULL , F_FILENAME text (255) NOT NULL , F_FILESIZE int NULL , F_REPLY_ID int NULL , F_TOPIC_ID int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Table 'FORUM_USERFILES' already exists.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWDOWNLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWUPLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Updating Forum Values..
DELETE FROM FORUM_MODS WHERE (M_NAME = 'Attachment' OR M_CODE = 'Attachment')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faMaxSize','512')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faExtensions','.zip:.mdb:.txt:.asp')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Attachment','1')
Value(s) updated succesfully
|
|
|
mb
Starting Member
9 Posts |
Posted - 26 April 2001 : 09:41:38
|
Could it be possible that database driver
not understand default syntax
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWDOWNLOADS int NULL DEFAULT 1
After edit the .dbs file without #1
the columns will write in the db
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 26 April 2001 : 14:55:16
|
You are correct, for some reason the access97 driver does not like the default syntax, and I can't find any info on what it might be, so what you did was ok
|
|
|
| |
Topic |
|
|
|
Topic Locked
