Subject | edit SQL question |
---|---|
Author | L.M. Bemmelmans |
Post date | 2003-07-24T15:20:35Z |
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
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