Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why Trigger failed, more details...
Message
 
To
25/01/2003 07:46:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743645
Message ID:
00745625
Views:
24
If it is not asking too much can you share the UDF with me.

>>Can we put !EMPTY(MyField) in field level validations. If so then what when the DBC rejects dues to an empty field
>
>Of course we can. We can put any expression that VFP considers valid.
>
>However, I don't like field-level validation, or record-level validation either, for that matter. The reason I don't like them is because they can fire too early - you can't say "evaluate those rules later". Field-level validation is fired as soon as the user leaves the field.
>
>The framework I use has a Form.Valid() event: I can insert validation rules there. The validation rules are evaluated when the user tries to save the record.
>
>Eventually, I ended up calling a single rule for each form, RecordValid("MyTable"). I defined RecordValid() as a UDF that checked rules I stored in a table, and showed the user the corresponding error messages.
>
>The fields in the validation table are Table, Rule, ErrorMessage, and a number indicating how strict the rule should be followed (can't save at all; warning, but user can save; and ignore completely).
>
>Rules evaluated this way are not strict, in the sense that you can bypass them in individual forms, or in the BROWSE window.
>
>To make the validation rules strict, I would call them from a trigger.
>
>Hilmar.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform