Hello,L.M.Bemmelmans!

IB/FB not support logical operation (=,<>,>,< etc...) for NULLs.
You should use "IS NULL" statement in SQL. And your statement should be as:

UPDATE myTable
SET id = :id,
myString = :myString
WHERE id = :old_id
AND (myString = :old_myString) OR (myString IS NULL)


WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...

----- Original Message -----
From: L.M. Bemmelmans
To: IBObjects
Sent: Thursday, July 24, 2003 6:20 PM
Subject: [IBO] edit SQL question


Hi,

I use a handbuilt editSQL:

UPDATE
myTable
SET
id = :id,
myString = :myString
WHERE
id = :old_id
AND
myString = :old_myString

If oldMyString = <null> then I get the error message that it's unable to
locate my record
if oldMyString <> null then everything runs OK

Leon






Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]