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