SAP SQL Anywhere

Question

If I had a table defined like below, how, from my application would I be able to get the next value for the "id" column before saving any data to the database?

create table people  
(  
     id not null default global autoincrement(100000),
     first_name varchar(100),
     last_name varchar(100)
);

alter table "people"
    add constraint PK_PEOPLE primary key (ID);

Accepted Answer

3

You can make a call to

select get_identity('people') from dummy;

which will get the next available number for that table.

permanent link

answered 15 Jan '10, 00:52

Calvin Allen
1.5k●23●26●38
accept rate: 25%

3

See also http://sqlanywhere.blogspot.com/2009/07/is-it-safe.html

(15 Jan '10, 08:09) Breck Carter

1

Excellent information! Thanks!

(15 Jan '10, 14:35) Calvin Allen

flat view

SAP SQL Anywhere

How do I get the next number for a global autoincrement column?

Follow this question

Related questions