Leaving "Holes" in a Table

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jul 16 22:23:20 CDT 2003


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



More information about the Valentina mailing list