>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.
- 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.