into table (column1,
column2, etc) value (value1, value2, etc) but don't include icon in your
list of columns and that will default it to 1.
Chris
-Original Message-
From: Chris Williams [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 04, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject
On Sun, 2001-11-04 at 13:52, Chris Williams wrote:
> I'm trying to create at table that inserts a default value into a field if
> nothing is supplied. If in interpret the documentation correctly this should
> be accomplished by something like this:
>
> CREATE TABLE Location (LocationID VARCHAR(10
I'm trying to create at table that inserts a default value into a field if
nothing is supplied. If in interpret the documentation correctly this should
be accomplished by something like this:
CREATE TABLE Location (LocationID VARCHAR(10) NOT NULL PRIMARY KEY, Name
VARCHAR(50), Address1 VARCHAR(5
