This topic is locked

$keys to gather primary key ID

3/8/2008 11:42:35 AM
PHPRunner General questions
D
dakk author

Wondering if $keys["ID"] works in gathering a primary key that is in oracle. Oracle doesn't auto increment. You make a sequence and a trigger. I can get the oracle id by doing a max value querry as a workaround but can't get the $keys to capture the last data row entered ID for use in another table for its foreign key.

Any oracle phprunner users out there?

Thanks

J
Jane 3/11/2008

Hi,
unfortunately $keys["recordid"] doesn't return key of added record in Oracle.

Use one of your workaround (select max value for example).