I'm using the DBI with ODBC on MS Access. I perform a SELECT. If this fails to find anything, I perform an "INSERT" and "SELECT MAX(id)".
Then I perform the exact same SELECT statement that I first performed and it does not find what I just inserted. Argghhh! I tried enclosing the "INSERT" and "SELECT MAX" in $dbh->begin_work and $dbh->commit but that did not help. The "INSERT" is successful, I can see it there. Why cannot I not find it? The "WHERE" clause I'm using with the "SELECT" is a sub set of the fields I'm inserting. 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>
