CREATE TABLE - setting DEFAULT value???

[RonMcNutt]

I'm creating a table in an MS Access97 dbase via SQL/ODBC from another application.

ODBCStatement := "CREATE TABLE Questions (QuestionID DOUBLE DEFAULT 0);"

Am I doing something wrong with this 'DEFAULT' statement? Can I even set the field default value this way? I've tried every combination I can think of... it always fails when there is a DEFAULT statement included. Any help GREATLY appreciated... I'm going for a motorcycle ride.... life's too short for this. :- )

 

[mwolf00]

From:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

A default value is the value that is entered in a field any time a new record is added to a table and no value is specified for that particular column. To set a default value for a field, use the DEFAULT keyword after declaring the field type in either an ADD COLUMN or ALTER COLUMN clause.

ALTER TABLE tblCustomers
ALTER COLUMN Address TEXT(40) DEFAULT Unknown

Notice that the default value is not enclosed in single quotes. If it were, the quotes would also be inserted into the record. The DEFAULT keyword can also be used in a CREATE TABLE statement.

CREATE TABLE tblCustomers (
CustomerID INTEGER CONSTRAINT PK_tblCustomers
PRIMARY KEY,
[Last Name] TEXT(50) NOT NULL,
[First Name] TEXT(50) NOT NULL,
Phone TEXT(10),
Email TEXT(50),
Address TEXT(40) DEFAULT Unknown)

Note The DEFAULT statement can be executed only through the Jet OLE DB provider and ADO. It will return an error message if used through the Access SQL View user interface.

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. - Rich Cook

 

[RonMcNutt]

Thanks for your response! Appreciated.