Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I lock a record.
Message
 
To
11/12/2006 10:31:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01176549
Message ID:
01176558
Views:
7
>I have an SPC inspection program. ISO guys are requiring that I lock the data so that it can't be edited after a certain point.
>
>How can I lock certain records in a table so that they can't be edited.
>
>It's in a database.

In addition to what others say, you can have a flag field in your table that gets updated according to your validation rules. Then the record editing can be disabled in your application, based on the value in the flag field. That will work whether table is in the database or not.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform