Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Log record changes
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00163453
Message ID:
00163668
Views:
27
John,

Since I bind directly to tables or views I just use code like this in my form.SaveChanges() method:
if ( AnyChanges( "machine" ) )
   TableUpdate( 1, .t., "machine" )
endif

* AnyChanges.prg 08-Jun-98

lparameter pcTable

return ! empty( chrtran( getfldstate( -1, pcTable ), "1", "" ) )
TableUpdate() handles the actual field level replacements.

>Thanks for your suggestion. I did lookup this function but can't really get clearcut idea of how to implement this to work correctly with my situation. How can I properly use this function to REPLACE a value in one of the field within the same table whenever ANY data within the same RECORD changes? Can this function be used to "automatically" update a field value regardless of if the change is via interactively or programmatically w/o duplicating code to constantly check this function in every form/code that use this table/views?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform