Sanjay Singh
|
| Posted: 03/31/2002, 8:57 PM |
|
I have been using CodeCharge for about a week now to test if it suits our
purposes. So far I think it is a brilliant product.
I have a page (Record style) that is used to add/edit data. I would like to
enhance it further:
1. If the user does not have sufficient permissions then the form is opened
read-only (most probably by changing all controls to labels).
2. If the record is marked complete (one of the fields is a boolean field
with complete/incomplete status), then the form will be opened read-only.
3. I want to record an Audit trail in a seperate table that will have the
name of the user and what changes he made.
Is there an easy way to do this that can then be easily expanded to other
pages as well.
Thanks in advance
Sanjay
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 04/01/2002, 3:17 AM |
|
1) and 2) deal the so called field level security described in this article
http://gotocode.com/art.asp?art_id=56&
http://gotocode.com/art.asp?art_id=129&
3) You should add some code into After Insert/Update evetns,
this code will record changes history , kinda
cn.execute ("insert into users (userid) value (" & session("UserID") & " )
")
--
Alex
CodeCharge Developer
"Sanjay Singh" <sanjays@standss.com.fj> wrote in message
news:a88pcg$asd$1@news.codecharge.com...
> I have been using CodeCharge for about a week now to test if it suits our
> purposes. So far I think it is a brilliant product.
>
> I have a page (Record style) that is used to add/edit data. I would like
to
> enhance it further:
>
> 1. If the user does not have sufficient permissions then the form is
opened
> read-only (most probably by changing all controls to labels).
> 2. If the record is marked complete (one of the fields is a boolean field
> with complete/incomplete status), then the form will be opened read-only.
> 3. I want to record an Audit trail in a seperate table that will have the
> name of the user and what changes he made.
>
> Is there an easy way to do this that can then be easily expanded to other
> pages as well.
>
> Thanks in advance
> Sanjay
>
>
|
|
|
|
|
