This topic is locked

HOWTO: Oracle sequences for primary key

6/21/2005 4:44:55 PM
ASPRunnerPro General questions
K
Keith@Caterpillar author

I'd like to use an Oracle sequence to populate my table's primary key. Where do I input the sequence name in the ASPRunner steps, or is this feature yet to be developed? I realize sql has identity seed and access has autonumber, but I'm using Oracle. Any help appreciated.
Keith

Sergey Kornilov admin 6/22/2005

Keith,
current update method used by ASPRunner doesn't allow to use Oracle sequences. I'll investigate what can be done about this.
Meanwhile you can solve this on the database side by using a trigger.