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