Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime of field change
Message
From
31/01/2007 21:43:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Miscellaneous
Thread ID:
01191228
Message ID:
01191233
Views:
9
>I would like to do a simple (I hope) validation rule for a true-false field so that when the field is changed to false, the datetime is recorded.
>
>I thought it would be easy to set a validation rule for the logical field, but I'm missing something. Can anyone provide a simple example for me?
>
>TIA

Simple expressions simply return .T. or .F.

However, you might invoke a UDF - which can be stored in the database stored procedures - which does the replace. I am not sure, though, whether this might generate an "illegal recursion" if you do it from a field validation. IIRC, something like this regularly happens when you try to pull the same trick from a trigger.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform