At 08:04 PM 7/04/2004 +0000, you wrote:

>I can't prepare the following sql statement on employee.fdb:
>
>update EMPLOYEE set LAST_NAME='XX'
>where ((LAST_NAME=:old_last_name1) or
> ((:old_last_name2 is null) and (LAST_NAME is null)))
>
>
>I get -804 Sql error code and Data type unknown message. I tried
>FIBPlus and IBX, both failed.
>I found that the problematic part is "(:old_last_name2 is null)"
>expression.
>If I remove that there's no trouble. What can I do?

If you have a column name old_last_name2, then just take the colon
off. You can't parameterise a column name, only a value, i.e.
column_name = :avalue

Your first criterion LAST_NAME = :old_last_name1 means
"(where) the column named LAST_NAME = the value supplied for the parameter
named 'old_last_name1'"

/hb

>Thanks in advance:
> Tamas Varga
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>