UPDATE using old value / incrementing values

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Jan 8 19:21:44 CST 2005


On 1/7/05 3:41 PM, "Sven Deichmann" <deichmann at werkbank.com> wrote:

> Hello,
> 
> I just stumbled upon a problem, I already had before.
> But this time it is a performance critical script and this could become
>   a serious problem as I don't want to select the old values before.
> Is Valentina really uncapable of accessing the current value within an
> UPDATE?
> If I use "UPDATE TrafficSums SET BytesOut=BytesOut+777 WHERE Host LIKE
> 'werkbank.com'"
> BytesOut for werkbank.com will be 0 afterwards.
> Why that?

Valentina 1.x cannot do this, Sven.

But Valentina 2.0 can.

So if you have timeline for your project at least month yet,
I think you can switch to V4MD 2.0.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------




More information about the Valentina mailing list