Creating a new table

[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 the 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 your table creation script as follows

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

Regards
Gopal