Simple example req. for autoincrement replacement in Interbase

r...@node0916.a2000.nl (Rob de Boer)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Simple example req. for autoincrement replacement in Interbase

Hi,

can somebody give me a small example of how to create a kind of
autoincrement field in Interbase. I created my own autoincrement but
I'm able to create dublicate numbers, which should be unique.

Rob de Boer

Oliver Sto

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Simple example req. for autoincrement replacement in Interbase

On Thu, 11 Mar 1999 08:54:49 GMT, r...@node0916.a2000.nl (Rob de Boer) wrote:

Quote

>can somebody give me a small example of how to create a kind of
>autoincrement field in Interbase. I created my own autoincrement but
>I'm able to create dublicate numbers, which should be unique.

create table foo (
ID integer not null primary key,
bar char(10)
);

create generator gen_foo_id;

create trigger tbi_foo for foo active before insert as
begin
if (new.ID is null) then new.ID = gen_id(gen_foo_id, 1);
end

That's all folks.

Oliver
--
5000'00" N
0836'32" E

Other Threads

1. REQ: source of simple concurrent-pascal example (parent/child processes in window)

2. REQ: Opinions on Apollo replacement of BDE

3. REQ: Benchmarks for BDE replacements

4. REQ: FREE - BDE Replacement for DBF

5. REQ:REQ:REQ: borland pascal unit: dealing with qemm

6. req: examples of tre

7. req: examples of trees, linked lists or pointers

8. REQ: DirectX 6.1 example

9. req: example GetFileVersionInfoSize

10. req: example GetFileVersionInfoSize