Hello there,
In our application, we want to keep track of:
who added/updated/deleted which record at what time.
Therefore I want to create a tabel called "ActLog" with these fields:
- cTableName
- reRecid
- daDate
- iTime
- cUser
Storing recid will give problems when dumping and reloading, because the recid stored does not have to be the same after loading.
I'm looking for a solution for storing the primary key fields & values in this table.
How can I do that?
Is there another solution for my problem? What?
Does anybody have any experience which could be helpful for me?
Thanx in advance ,
Maurice
In our application, we want to keep track of:
who added/updated/deleted which record at what time.
Therefore I want to create a tabel called "ActLog" with these fields:
- cTableName
- reRecid
- daDate
- iTime
- cUser
Storing recid will give problems when dumping and reloading, because the recid stored does not have to be the same after loading.
I'm looking for a solution for storing the primary key fields & values in this table.
How can I do that?
Is there another solution for my problem? What?
Does anybody have any experience which could be helpful for me?
Thanx in advance ,
Maurice