< snip >>>
>>Does'nt this smell like another bug ?
>
>Yes and no. There's a general rule in SQL Select (and it obviously applies to SQL Update) that it uses the tables AGAIN internally, so any function which uses aliases will produce a result based on the alias outside the SQL statement, and not the one used inside. So, it will behave as a constant, because while the statement is executing, nothing is happening in that alias - record pointer doesn't move.

Hi Dragan,

As I pointed out in the Message #588459 the SQL Update works on already open tables.

< snip >