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

Reply via email to