getting Index after INSERT INTO

[Ruslan Zasukhin]

on 8/21/03 4:20 AM, Andrew Sinning at andrew at learningware.com wrote:

> Thank you Ruslan.
> 
> One point of clarification:
> 
> Does every table have a RecID?

YES
 
> And this value is automatically incremented each time a new record is
> added?

It can be reused for deleted tables !!!

RecID -- is physical address.


> And this is always a unique value?

YES of course

> Eg, if I make 100 records and then
> delete the last 50, the next new record will have RecID 101, not 51,
> correct?

NO. After deletion of 50,
Numbers will be 51, 52

If you need auto increment you can do like in sybase or other dbs.
Define own small table that keep last counter value,
And use it to define SELF next ID value.


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