im trying to create a table as shown below. i tried to set a default value for a certain field but an error is occuring. can you give me insight where is the hole in my coding? im using asp and the database is MSACCESS.
SQL_CREATE = "CREATE TABLE JOB_NAME" &_
"(SER_NO AUTOINCREMENT," &_
"JOB_ID INT," &_
"ORDNO VARCHAR(255) NOT NULL," &_
"URINO VARCHAR(255)," &_
"EUSER VARCHAR(255)," &_
"JOB_NAME VARCHAR(255)," &_
"P_S SINGLE," &_
"T_FC SINGLE," &_
"URIAGE_D DATE," &_
"SAGYOU_KAI _D DATE," &_
"SAGYO_KANY O_D DATE)"
db.Execute SQL_CREATE
everytime i put a default(for example: DEFAULT 'AAAAA', or DEFAULT 0) in any field above, an error is occuring. what do you think is the cause? thanks in advance.
regards,
SQL_CREATE = "CREATE TABLE JOB_NAME" &_
"(SER_NO AUTOINCREMENT," &_
"JOB_ID INT," &_
"ORDNO VARCHAR(255) NOT NULL," &_
"URINO VARCHAR(255)," &_
"EUSER VARCHAR(255)," &_
"JOB_NAME VARCHAR(255)," &_
"P_S SINGLE," &_
"T_FC SINGLE," &_
"URIAGE_D DATE," &_
"SAGYOU_KAI _D DATE," &_
"SAGYO_KANY O_D DATE)"
db.Execute SQL_CREATE
everytime i put a default(for example: DEFAULT 'AAAAA', or DEFAULT 0) in any field above, an error is occuring. what do you think is the cause? thanks in advance.
regards,