V4MD - reusing recids

[Ruslan Zasukhin]

On 4/19/05 8:29 PM, "Scott Runkel" <srunkel at hypix.com> wrote:

Hi Scott,

> I have a project using Valentina 1 for Director. The database will be updated
> each year by deleting a bunch of old records and adding a bunch of new ones.
> But
> about 80% of the records from one year to the next will be preserved.
> 
> My problem is that I'm trying to use the recids in my application to store
> little lists of database records for the user to save. So they might put 5 or
> 10
> items into their custom list, which might be articles or images, but are
> referred to internally by their recid. Then I realized that next year, when I
> update the database, some of the existing recids will be reused. So a person
> might have saved an article on one topic and the next year they'll pull it up
> and it could be a different article.
> 
> Is there a way to "lock" all recids so new ones are always generated, perhaps
> based on the highest existing recid? The idea is that no old, deleted recids
> would get reused.
> 
> Any suggestions/solutions appreciated.

Well, it is possible

1) not delete old records

2) after deletion add some number of blank records until all deleted records
will be re-used and you start get RecID values bigger of latest record on
table.

This is not good of course, because in this case you table will always grow
in size.


-- 
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]