Looking for the source of LASTUSER value in CONTHIST

[codelphi]

I have built a trigger that keeps track of any deleted entries from CONTHIST. The only problem is that it does not identify the user doing the deleting. When somebody changes an entry in CONTHIST it records their username into the LASTUSER column. Where is it accessing to show who the executing user is and through which keys is it joining to get that information?

 

[goner]

GoldMine doesn't record that information. You could, potentially, make sure each of your users is assigned a unique MSSQL login id and then make that part of the tracking you do in your trigger.

Beyond that, if users deleting records is a problem in your install, you could always curtail their deletion rights.

Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[DJHunt]

I would think that this would be available in the ContHist record. Here is the specific structure that I would be looking at:

LastDate DateTime 8 Last Modified on Date
LastTime VarChar 5 Last Modified at Time
LastUser VarChar 8 Last Modified by UserID

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US