OpenEuphoria

RE: EUSQL get_next_autonumber

• Posted by "sixs" <sixs at ida.net> Nov 21, 2003
• 606 views

Matt,
I 'm having trouble with the sateement.
Is this sort of correct?
ok = run_sql( "CREATE TABLE counter CONT AS AUTONUMBER ")
Jim
-----Original Message-----
From: Matt Lewis [mailto:matthewwalkerlewis at yahoo.com] 
Subject: RE: EUSQL get_next_autonumber




sixs wrote:
> 
> 
> Matt, 
> Are you saying that EUSQL will assign a Key number to the record if 
> I want it to have integer numbers? If I want an key made of alpha 
> values, say a persons initials,  that I can do that?
> Jim

EuSQL allows any values for the key (as long as they are unique, of 
course).  The AUTONUMBER data type is unique, in that you don't supply 
the values.  EuSQL stores the last number used, so that as each record 
is created, a unique number is generated for that field, which can be 
the primary key or any other field.

I think I may be releasing a new version of EuSQL (and EDB) this weekend

or early next week.  Nothing major for EuSQL--some optimizations and a 
couple of bug fixes.  About the same for EDB.

Matt Lewis



TOPICA - Start your own email discussion group. FREE!