Well,<div>I&#39;m a Java nerd. In java theres a way you can specify that you want the generated keys returned to you upon insertion into a table with auto generated keys. Since JDBC works with virtually any database, I think that should tell us that there is a way to get the results by maybe using a handle returned from the insert statement. Check out the docs for whatever drivers you are using to connect to the db and you&#39;ll most probably find it there.<br>
<br><div class="gmail_quote">On Wed, Jan 19, 2011 at 3:05 PM, James Nzomo <span dir="ltr">&lt;<a href="mailto:kazikubwa@gmail.com">kazikubwa@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Locking may be a good option but the performance to integrity tradeoff .....<br>Locking might also frustrate users when trying to insert<br><br>Anyway, I think i&#39;ll use a different way of getting the primary key other than relying on the last insert<br>


Or maybe employ the use of a surrogate key<br><br>I&#39;ll research on the matter then share the best solution in my view<br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Solomon Kariri,<br><br>Software Developer,<br>Cell: +254736 729 450<br>Skype: solomonkariri<br>

</div>