audit trail, take 2

[Derek Atkins]

Dave Peticolas <dave@krondo.com> writes:

> Is the xaction_id also a guid, in the sense of being globally unique?

I don't believe it is "globally" unique -- it is shared across all the
history of a particular transaction.

> What I'm really getting at is, for a given transaction, will there be
> some 'stable' GUID with which you can quickly access the most recent
> version? By stable I mean that you can always use that same GUID to
> get the most recent version.

You can easily do that using the xaction_id with something that looks
like:
	SELECT (*) from transaction where xaction_id=AAAA and status=A

Which should retreive one and only one response (since you should only
have one 'A'ctive record).

Hopefully David Merrill will correct me if I am wrong. ;)

> dave

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord@MIT.EDU                        PGP key available