Message
From
11/12/2006 10:41:19
To
11/12/2006 10:31:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01176549
Message ID:
01176554
Views:
9
>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.
You can USE ... NOUPDATE.
The LOCK() function can hold data by one user such that another can't get at it, but only during the 1st user's session, and that doesn't preclude User 1 from updating.
AFAIK there's no way to mark a table such that opening it in Foxpro it can't be updated. You can only control this through code as above.
>
>How can I lock certain records in a table so that they can't be edited.
>
>It's in a database.
You can USE ... NOUPDATE.
The LOCK() function can hold data by one user such that another can't get at it, but only during the 1st user's session, and that doesn't preclude User 1 from updating.
AFAIK there's no way to mark a table such that opening it in Foxpro it can't be updated. You can only control this through code as above.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.