Subject Re: [firebird-support] Re: Stored procedure to return primary key after insert
Author Helen Borrie
At 09:55 AM 30/09/2006, Adam wrote:

>Use semi colons where you want to include variables on the right hand

No, that's not the rule. The rule is that you use the colon prefix
wherever you refer to the variable in a DSQL statement, otherwise not.

>Assuming you meant.
>CODE_MEM = :CODE_MEM || :id_mem;

No. Would be
CODE_MEM = CODE_MEM || id_mem
or rather
CODE_MEM = coalesce(CODE_MEM,'') || id_mem;