Accepting NULL values

[t16turbo]

Hi all,

not sure if this is the correct forum to use, but I have created a simple table in sybase.

I'm using a Lotus tool to populate th table with data from a Notes datasource.
The process fails because it is trying to insert null values into sybase.
My SQL is as follows:

CREATE TABLE EnhAudit
(ProjectNo CHAR(8),
CreatedDate DATETIME,
FieldName CHAR(35),
OldValue CHAR(35),
NEWValue CHAR(35),
CreatedBy CHAR(40))

how can I instruct it to accept NULL values in the OldValue field?

thanks in advance..

 

[tinkuK]

Hi
change the script as follows

CREATE TABLE EnhAudit
(ProjectNo CHAR(8),
CreatedDate DATETIME,
FieldName CHAR(35),
OldValue CHAR(35) null,
NEWValue CHAR(35),
CreatedBy CHAR(40))

Gopal2

 

[t16turbo]

thanks tinkuk,
thats just the job!