Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update a field automatically ?
Message
From
21/11/2008 07:19:58
 
 
To
21/11/2008 05:52:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01363438
Message ID:
01363442
Views:
14
>i added a field named DATECUR in a table. i want, whenever a record is added or edited, the database automatically writes the current date in that field.
> how can i do it ?

Do you use a native Vfp DBC as your backend? If so, you can create a "Stored Procedure" in your database that updates your timestamp field (in the Database Designer) and run that SP as yourTable's "Record Validation Rule" (in the Table Designer).


hth
-Stefan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform