OpenEuphoria

Re: EDS Autonumber

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Dec 02, 2005
• 514 views

cklester wrote:
> 
> Greg Haberek wrote:
> > 
> > }}}
<eucode>
> > global function db_next_key()
> > 
> >     integer count
> > 
> >     count = db_table_size()
> >     if count = 0 then
> >         key = 0
> >     else
> >         key = db_record_key( count )
> >     end if
> > 
> >     return key+1
> > end function
> > </eucode>
{{{

> 
> You'd need something like
> 
>    while keyExists( count ) do
>         count += 1
>    end while
> 
> so as to avoid duplicate keys in cases where records get deleted.

No, his method would work fine, because EDS always keeps the records sorted
by key, so the last record is guaranteed to be the highest number currently
in the table.  Note that count is the record number of the last record, and
key is the acutal key value.  Of course, you'd need to define 'atom key'
to make this routine work...

Matt Lewis