tsturgeon
Posts: 7
|
| Posted: 12/20/2005, 11:07 AM |
|
I want to log the name of the currently logged in user into each INSERT, UPDATE.
How do I do this?
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 12/20/2005, 11:59 AM |
|
Are you tracking every insert / update per record or are you just recording the last change to a particular record???
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 12/20/2005, 12:08 PM |
|
This is assuming that you are only storing the last insert/update per record.
On your form you can have a hidden field which will have the current userid or name (as the default). Whenever the user inserts a new record the default userid/name will be added with the record. For updates, you will want to put in custom code in the Before Update event that will change the hidden field value to the current user.
|
|
|
|
tsturgeon
Posts: 7
|
| Posted: 12/20/2005, 1:11 PM |
|
I got it...I use an Expression in a customer insert/update, with the following function:
CCGetSession("UserLogin")
I am only logging the last user.
|
|
|
|
|
