Is it possible to change record innot active

[Quant]

Hi,

I have a question, is it possible that when a record has a certain status it cannot be changed annymore.

For instance i have records in a database with the status "paied" then the record may not be changed anymore.

Thanks,

Frans

[Vaughan]

Yes. Search the forums for "record locking".

[Quant]

Hi Vaughan,

Thanks for the reply.

I found this article from Steven H. Blackwell:

In several different venues over the past several days a number of different developers have inquired about processes for locking records in a table against further changes once a set of business rules are satisfied.

Unfortunately in some instances the recommendations given in answer to these inquiries can fail and leave records vulnerable to hacking. These include the idea that layout access manipulation can somehow protect the record against being altered.

In my view the best and most secure way to institute a record lock process is to use the Record Level Access privileges options found in the Edit Privilege Set options.

For any given table, create a field named “Lock” of the type number, auto-enter data of 1. Check the flag saying “Prohibit modification of value during data entry.”

Then in the Manage Accounts & Privileges-->Privilege Sets-->Edit Privilege Sets--> Records, select Custom Privileges. In the Edit column for the table you want, select limited. Pick the field “Lock” from the list of fields.

In the Field Access column, select the field “Lock” and mark it for No Access. This affords maximum protection against the field’s being modified in an unauthorized fashion and altering the state of the record.

When the circumstances occur that cause you to want to lock the record, use a script set to “Run script with full access privileges” to set the field “Lock” to 0. If “Lock”=1, the default entered value, the record can be edited. If “Lock”=0, the record cannot be edited.

I tried this but i don't get the result as described, i don't see the records in a portal anymore.

What do i wrong....??

Thanks,

Frans

[Vaughan]

If the primary or foreign key field is marked no access, then the data in it cannot be seen... so it won't show up in relationships.

[Quant]

Hi Vaughan,

I figured it out, but i have one thing that is not working like i would.

I have a delete button on every row in a portal, i stil can use it though i restrtict the user to make any changes in the record,

How can i avoid this....?

Thanks,

Frans

[Vaughan]

You need to lock the related records if the parent record is locked.

[Quant]

Hi Vaughan,

Thanks for your reply.

The related records are locked but i stil can use de delete button.. is there a way to avoid this?

Thanks,

Frans

[Vaughan]

Change the privilege set to prevent delete if the record is locked.

[Quant]

Hi Vaughan,

Thanks for your reply, it works.

Frans