Is it possible for a user to lock a record so that no changes can be made to it?

For example. A record is entered on Monday. and on Wednsday, a supervisior would go in and lock that record so that no changes can be made. it can still be searched on, just not changed.

I didnt see anything in docks on locking records expect when Sesame does it on it's own when different users are viewing the same data. But it seems like giving that ability to a user would also be possible.

Thanks
Derrick

Thanks.
According to the docs, readonly() affects individual elements. So I'd need to set it for each element on the form.

Could you elaborate on how I could use something like pushformattributes to take care of the entire form.

Derrick

Hi, I finally got time to implement the locking code but here's a problem that came up.

First of all (this isnt the problem part) I created a locking subroutine


[code]
subroutine lock_record()

     var vLockDate as Date
     var vElementList as String
     var vTabList as String
     vLockDate = @Date -2

     vTabList = "Orders2, order, TabPage, TabPage0, TabPage1,TabPage2, TabPage3,TabPage4, TabPage5,
TabPage6, TabPage7, TabPage8, TabPage9, TabPage10, TabPage11, TabPage12,TabPage13,TabPage14, TabPage15, TabPage16, TabPage17, TabPage18"
     vElementList = @StringArrayElementList()

     If @ServerDate() >= vLockDate Then
     {
           StringArrayAttributes(vElementList, ATTR_ID_READ_ONLY, 1) //Set all elements contained in vElementList to Read Only
     
           StringArrayAttributes(vTabList, ATTR_ID_READ_ONLY, 0) //Set all tabs to read/write
     }



end subroutine
[/code]

Now here's the problem part. It sets everything to ReadOnly. Including the tabs on the form. So it's no longer possible to click though the form to look at the information. I tried to work around it by immediatly setting the form and tabs to read/write but they are still grayed out and unclickable.

How can I make the tabs usable again while leaving the form readonly?

Thanks,
D

Ouch. Thats a goofy mistake to make.
Thanks. It works perfectly now.

D