Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Lock Problem by Table Definition!
Message
From
20/10/1998 21:36:24
 
 
To
20/10/1998 16:34:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00148461
Message ID:
00148739
Views:
17
>Hiya ---
>
>If I understand what you are trying to do correctly, you could use a table update trigger to trap low values of gAccessLevel and -- to block external access --- test for the existance of gAccessLevel and disallow changes if the var does not exist.
>



You are right, but I put it at the Field Validation part, not Table Update Trigger! It is at the Field definition page on Table Designer!



>
>
>>I want to make a field lock so that even user Do Not use the system directly, some of the field are not allowed to edit or in my application, not allow user to edit that field!!
>>
>>So, I use a Global Variable to control it and set the Update Validation on field in table definition to:
>>gAccessLevel > 500
>>Message for Invalid:
>>"Your Access Level is not enough to edit this field!"
>>
>>But I wonder that even in browse window, if the gAccessLevel is not enough and I don't change the value of field, that invalid message still come out and nearly impossible to leave!
>>
>>What are the better way to skip invalid message if low access user DO NOT edit that field but give an auto-reverse instead of system asked messagebox!?
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform