[V4RB] Updating fields with value from itself

[Ruslan Zasukhin]

On 3/28/05 5:24 PM, "Christer Olsson" <christer at ljusaideer.se> wrote:

> Should I be able to update a field in a table with a calculated value with
> something like:
> 
> UPDATE myTable SET myFld = (myFld - 10) WHERE myFld2 = 'x'
> 
> I want the field "MyFld" to be 10 less than it was before the Update.

Yes Christer, this should work.


Please note, in fact SUBJECT is related to VSQL but not to V4RB

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]