VStudio - Can I make RecID my Primary Key? - I recommend - NO

[Ruslan Zasukhin]

On 1/6/07 3:32 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> MSAccess was doing this at one time.
> Where we would execute a compact/repair,
> And find the indexes for Primary Keys had been resequenced to recover the
> numbers.  As I first recall, whether deleted or not. lol
> 
> But changed in later versions to recover the delete space WITHOUT reuse of
> the RecIDs.
> 
> --
> 
> The only way around this, that I recall, is to setup Cascade Deletes where
> you can't delete a parent record (i.e. unique RecID) until all associated
> child records have been previously deleted.  Thereby removing any
> association to the specific RecID.
> 
> --
> 
> WARNING - any kind of archiving of live db to history db using the RecID
> (after Valentina recovery of RecIDs) will make the history db RecIDs
> duplicated.
> 
> --
> 
> Unless something has changed in v3 or there is some doco I havn't read yet,
> my recommendation is NOT to use RecID in this manner.

And I wonder if you have read THIS pages:
 

<http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
ntation:vkernel:vlink:vlink>


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]