Leaving "Holes" in a Table

[Gunnar Swan]

The purpose of this is to fill where there are now empty records. If the empty record space was not used, and new records were added to end, then database would 
grow in size extremely fast, and you would constantly have to 'pack' the database.

Better to not rely on record id as primary key.


7/16/03 12:23:20 PM, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:

>on 7/16/03 21:18, Ken Ray at kray at sonsothunder.com wrote:
>
>Hi Ken,
>
>> When I delete record ID 507 from a table of 1000 records, and then add a new
>> record to the table, it gets #507, not #1001 as I would expect.
>
>This is pointed in docs. This is feature of Valentina.
>
>> Is there any way to make this happen where #507 remains a "hole", and a new
>> record #1000 is added?
>
>No. 
>
>Will be added auto increment fields.
>For now you can self do this using special table where you store last ID.
>In Sybase and Oracle this is named sequence.
>
>-- 
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]
>-------------------------------------------------------------
>e-mail: ruslan at paradigmasoft.com
>web: http://www.paradigmasoft.com
>
>To subscribe to the Valentina mail list go to:
>http://lists.macserve.net/mailman/listinfo/valentina
>-------------------------------------------------------------
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>


Best Regards,
Gunnar Swan
Practice To Pass
1.888.307.2050
http://www.PracticeToPass.Com