Null Integers

Post Reply
bignose
Posts: 1
Joined: Tue May 22, 2001 1:15 pm

Null Integers

Post by bignose »

I'm trying to insert a NULL value into a column that is
expecting an integer, i've tried

INSERT INTO mytable (intvalue) VALUES (NULL)
as well as
INSERT INTO mytable (intvalue) VALUES ('NULL')

both of which resulted in a 0 being inserted.

with other DMBS's I've used this is ok..

-- Jeff
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Null Integers

Post by John »

Texis does not currently support NULL values, and so you will get a 0 instead.
John Turnbull
Thunderstone Software
Post Reply