If I use the auto-increment feature for a couple of normalized relations, how do I insert into them?
Specifically, when I insert into a relation with the autoincrement feature on the primary key, how do I get the value of the index on the newly created row so I can use that the value of a foreign key in another relation? I'm using DBI for a multithreaded application, sometimes for MySQL and sometimes for PostGreSQL. In MSAccess, I know, I can only say SELECT MAX(ID) which does not work well for a multithreaded application. Thanks, Siegfried -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
