11 Sep
2002
11 Sep
'02
12:30 p.m.
Hi! Sorry for the somehow off-topic subject, but the SQL reference doc I've downloaded from SAPDB website hasn't been that helpful. I want to create a auto-incremented primary key on a table. On SQL Server it's easy since you can set an attribute to auto-increment. On Interbase it's not that easy: you have first to create a generator and then a trigger that will increment that generator on each insertion. How can I do that on SAPDB? I suspect it might have something to do with SEQUENCES, so I've just created one, but now I need to associate it with the primary key. How can I do it? Using a trigger? Sorry, but the SAPDB SQL doc is anything but "user-friendly". thanks, Vitor Varalonga