Board index » jbuilder » NULL

NULL


2003-11-13 08:13:25 PM
jbuilder13
Hello,
does anyone know how to assign null values in an array
of type short? When a new table is initialized all of its values are set to
0. I would like to have them NULL.
I saw that in C++ NULL in a table of shorts is like 205.
Can anyone help?
 
 

Re:NULL

i have looke in d5 local sql help for the use of NULL but cannot any
refrence. I want to use something like
where (myfield = null )
but i get the message that null is the incorrect use of a rerseve word.
please can you help
sam
 

Re:NULL

You must use IS NULL clause:
SELECT *
FROM yourTable
WHERE (yourField IS NULL)
"samantha" <bdsltd.net>wrote in message
Quote
i have looke in d5 local sql help for the use of NULL but cannot any
refrence. I want to use something like

where (myfield = null )

but i get the message that null is the incorrect use of a rerseve word.
please can you help
sam


 

{smallsort}

Re:NULL

Samantha wrote:
Quote
where (myfield = null )
where (myfield is null )
... Joe
Member of the UK Borland User Group