ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

Reply
Distinguished Contributor
petervose
Posts: 309
Registered: ‎10-02-2003
Message 1 of 2 (384 Views)

ADOLisp - Select rows with null values

384 Views, 1 Replies
01-02-2013 10:19 AM

Hi - I'm attempting to update a database so that all fields in a specified column that have a null value and are of datatype number are allocated a value of 0 (zero), but I'm having trouble selecting the offending rows..

my statement is

"select * from crossings where pipeline_id = null"

and this returns nothing (although I know there are some in there because if i run the following:

"select * from crossings where pipeline_id <> null"

it returns all rows that have a value and omits those that don't (ie the ones that I want)

Anyone know what I'm doing wrong?

Distinguished Contributor
petervose
Posts: 309
Registered: ‎10-02-2003
Message 2 of 2 (375 Views)

Re: ADOLisp - Select rows with null values

01-03-2013 02:07 AM in reply to: petervose

Realised I should use keyword "IS" instead of using "="

select * from crossings where pipeline_id IS null

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!