Re: Problems with NULL and UPDATE in OCI programs

From: BrianEno <brianeno_at_aol.com>
Date: 1996/09/21
Message-ID: <51vrhf$7mi_at_newsbf02.news.aol.com>#1/1


The problem probably is that you are setting the value to equal NULL by setting the NULL Indicator to -1. Therefore it is trying to do an update using a column in the where clause where it is "= NULL" and this never works in SQL. It must have the format of column "IS NULL" and not "= NULL". I solved this using a kludge of two SQL statements and parsed both of them using a different CDA. The first is for non null values and the where part is a standard non null value and another where the SQL statement has the the format of "where searchcol IS NULL". Received on Sat Sep 21 1996 - 00:00:00 CEST

Original text of this message