Helen Borrie wrote:

> At 09:55 AM 30/09/2006, Adam wrote:
>
>
>> Use semi colons where you want to include variables on the right hand
>> side.
>
> 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;
>
> ./heLen
>

Yes, yes, yes heLen! Four replies and I was starting to get worried :)
There are actually places (or tools) where things won't work using the
colon outside DSQL.

/Dany