Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duplicate Validation
Message
 
 
À
20/02/2002 12:55:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00622656
Message ID:
00622699
Vues:
19
Bill,

I don't think, it's something built-in Foxpro. You have to program it yourself.

>Actually, I'm looking for a way for the validation rules to AUTOMATICALLY recognize that the field has already been validated (in the view) and not execute again.
>
>I'm hoping that there is some way for the rule to recognize that TABLEUPDATE() is executing and just return .t.
>
>Or in the alternative, somehow have the rule set a flag when the view is being edited, so that when TABLEUPDATE() is issued 1) the rule won't execute and 2) clear the flag. But the flag would also have to be cleared if TABLEUPDATE() is not issued.
>
>
>>Either don't copy validations into view or have some flag, which can trigger validations if needed. Your validation rule would be:
>>(vartype(myFlag)='L' and not myFlag) or myRule()
>>
>>So, if you set myFlag to .f. your validations would return .t. without firing the rule.
>>
>>>I'm using VFP 5.0a
>>>
>>>All my views have the field validation rules copied from the underlying tables.
>>>
>>>I'm looking for a way to keep the field validation rules from executing twice, 1st when the view is edited and 2nd when TABLEUPDATE() is issued.
>>>
>>>Any ideas?
>>>
>>>TIA
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform