Must 'somefield' support null values? If there is some credible default
value, then define the column as NOT NULL, and use the defaults.
Otherwise, I guess, you'll have to dynamically build your SQL to read 'where
somefield is null' 1% of the time.
----- Original Message -----
From: Mark Derricutt <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Sent: Wednesday, October 20, 1999 11:39 AM
Subject: [DUG-DB]: update sql's and null where clause entries...
> I have a slight problem, I have an update query which works 99% of the
> time, unless the existing field is null.
>
> In my where clause I do "where somefield = :old_somefield" (using an
> UpdateSQL object, which fails when somefield is null before editing. Is
> where anyway around this?
>
> --
> Mark Derricutt, He that brings forth electronic life.
> Now Playing: Tori Amos - To Venus And Back
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
