OpenEuphoria

RE: EUSQL get_next_autonumber

• Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Nov 21, 2003
• 441 views

sixs at ida.net wrote:
> 
> 
> I am trying to have a table with an automatic number key and I found
> this function in eusql.e. Is that the proper use of this function?
> jim
> 

I'm not sure how it is that you are using it.  The proper way to use 
AUTONUMBERs in EuSQL is to create a field of that data type.  It may be 
the primary key or any other field.  From the user's point of view, this 
field is read only.  If you try to change the value, you'll get an 
error.  EuSQL will automatically assign the next number in sequence 
whenever you create a new record.  The function, get_next_autonumber() 
is there for convenience, in case there is some reason why you might 
need to know what the next number will be.

Matt Lewis