Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Triggers?
Message
From
14/08/1999 10:06:41
 
 
To
13/08/1999 17:40:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00253416
Message ID:
00253753
Views:
24
>Hi Erik and Jim,
>
>Yep, I knew that triggers where Table-Level features, I just got some conflicting info that was quickly corrected (if you look back over the thread). However, I never considered putting a function in "Rule" to do more than validate the value, and create a psudeo-field-level trigger, right? Anyways, thats what I've done for the time being.

Not su re exactly what you are trying to accomplish- but a reason to put code in the validation rule:

Validation rule is the only way to get a timestamp function built in to your table. By calling the correct stored procedure from the validation rule, you can have the dbc automatically populate a timestamp field with DATETIME() and a username field with the current user's login name.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform