Hi!
I run your sample without ANY change and both OldVal() and curval() return different values BEFORE and AFTER update, as supposed to work.
>Hi people...
>Im trying to use the CurVal() and OldVal() functions and they make me crazy because dont work as im espected...
>in te help there is this example:
>*-------------------------------------------------------------------
>CLOSE DATABASES
>CLEAR
>CREATE TABLE mytable FREE (cDigit C(10))
>INSERT INTO mytable (cDigit) VALUES ('One')
>SET MULTILOCKS ON && Allow optimistic table buffering
>= CURSORSETPROP('Buffering',5) && Optimistic table buffering on
>REPLACE cDigit WITH 'Two' && New value
>? "Current value: " + CURVAL('cDigit', 'mytable')
>? "Old value: " + OLDVAL('cDigit', 'mytable')
>= TABLEUPDATE(.T.) && Commit changes made to table
>? 'Table changes committed'
>? 'New current value: ' + CURVAL("cDigit", "mytable")
>? 'New old value: ' + OLDVAL("cDigit", "mytable")
>*--------------------------------------------------------------------
>Ok if you execute this portion of code in the command window you maybe expect to have prited in your screen two differents values from the 'current value' and 'old value' but it doesnt works to me and other workmates, i 've been forgotten some setting or somethig???
>I will appreciate if any of you can explain to me why this dont work to me...
>thanks in advance
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.