Is there a reason why a parameter can only be used once within a sql
statement?

Example:

strSQL := 'update user_table set user_name1=:PARAM1, user_name2=PARAM1';

Just curious.

Thanks,
Jeff

I think it's just a bug

Hi, Jeff!

If this is the exact text of your query, then Param1 in the second statement
is directly intepreted as a value, not an alias. You have forgotten the ':'
in front of Param1. I am not sure if this solves your problem (in fact I
don't even know what your query returns), but anyway.

//Bent Arne Blegen