ID numbers generation

Question

i am trying to code for my system in NetBeans IDE 6.5 to auto generate ID numbers for me like autonumbers in Ms Access. does any one have any ideas about going about that?i mean code for it.

I really don't think the MS-ACCESS tag adds anything here, as the question isn't about Access or Jet or ACE, but about how to do something like that in a different environment. In other words, Access is not relevant to the answer for the question at all. — David-W-Fenton, Jul 03 '10 at 22:48

score 0 · Answer 1 · answered May 20 '09 at 11:18

0

What database system are you using? If it's something SQL based:

CREATE TABLE $tblname (id int(10) NOT NULL auto_increment PRIMARY KEY (id))

Try using auto_increment , such as in the example above.

answered May 20 '09 at 11:18

Alya

262
2
10

score 0 · Answer 2 · answered May 20 '09 at 11:35

0

If you're using JavaDB you need the GENERATED AS IDENTITY option on a field in your CREATE TABLE statement.

answered May 20 '09 at 11:35

David Webb

190,537
57
313
299

score 0 · Answer 3 · answered May 20 '09 at 11:39

0

In the Windows API you can create a Guid. I'm sure there is some similar UID API for Netbeans.

answered May 20 '09 at 11:39

kenny

21,522
8
49
87

score 0 · Answer 4 · answered Jun 05 '09 at 23:09

If you're using Oracle, you will need a sequence for each table.

once you have the sequence you can create a trigger like this:

Create or Replace trigger incrementOnInsert
before insert on TABLE
for each row
begin
    select sequence.nextval into :new.id from dual;
end;

ID numbers generation

4 Answers4