Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffer problems within Update Trigger
Message
 
To
03/05/2002 12:33:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00652180
Message ID:
00652529
Views:
23
John,

This is correct

CURVAL(field) = old value
OLDVAL(field) = old value
table.field = new field

unless someonoe else has altered the table and in that case CurVal() will tell what value the table actually has on disk (the other user's changes).

Because the table has been updated during the trigger the only way you will get your data is to read the Table.FieldName information as this is the buffered changes that are pending during your trigger.
Previous
Reply
Map
View

Click here to load this message in the networking platform