Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alias in data validation rules
Message
De
10/04/2008 05:20:52
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
10/04/2008 04:39:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01309609
Message ID:
01309611
Vues:
7
Exactly

If you use views or CA's and run TABLEUPDATE(), the Alias of the CA will be in scope, but the validation of the target cursor (table) will fire. Since those table knows nothing about how they is called (tableupdate, replace, update, change in browse window) it will run the rule against its own alias. IOW it will change the alias internaly.
sele bla
replace OtherTable.field with FieldFromBla
will fire the fule for "field" in "OtherTable" and while running this rule "OtherTable" will be the return of ALIAS().

Agnes



>Hi,
>
>In VFP9 help, under the topic Field and Record Validation Rules which discusses data validation rules, a Note:
>
>"When a trigger is called, the Alias is always that of the cursor being updated, regardless of the Alias selected in the code that caused the trigger to fire."
>
>What is the Alias in the above note?
>
>Does it mean in the validation rule, if I have abc = ALIAS(), abc will be assigned the alias of the cursor which contains the field being validated (instead of active workarea alias when the validation check is triggered)?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform