> >You cannot differentiate between ACTIVE and INACTIVE in the CONTENTS
> table,
> >so that if you had three versions in the BACKUPS table, you would match
> each
> >of these three times in the contents table...
>
> Paul - In the BACKUPS table, a null value for the DEACTIVATE_DATE column
> indicates that the file is the Active copy, and a date value
> indicates an Inactive copy, if that helps.
> Richard Sims, BU
>
This also seems to be reflected in the STATE column, but it is the lack of
this in the CONTENTS table that means I cannot join them. If the OBJECT_ID
field was also in the CONTENTS table that would be a solution. I've thought
about this quite a bit today and I think there's no solution :-(
Thanks,
Paul.
--
Sent through GMX FreeMail - http://www.gmx.net
