Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table security
Message
From
20/05/2003 09:20:29
 
 
To
20/05/2003 06:48:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00790261
Message ID:
00790401
Views:
15
If the table is in a database, then yes. If it is a free table then, I dont know of a way.

If the table is in a database, you can specify an update trigger. if that trigger returns .t. then the table can be updated, otherwise it will not be updated. If you wanted the user to be prompted with a dialog box to enter a password or something, you would probably have to put that code inside a stored procedure.

I have a simpler version here. I have a field called mytable.locked
update trigger is set to !(mytable.locked) where locked is a logicial.

so if locked=.t. then the table can not be updated.
Previous
Reply
Map
View

Click here to load this message in the networking platform