in reply to Perl MSAccess SQL UPDATE

What kind of module are you using to access MSAccess? It doesn't look like a DBI/DBD-combo to me.

We really need to know that before we can give some useful help.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Replies are listed 'Best First'.
Re: Re: Perl MSAccess SQL UPDATE
by iburrell (Chaplain) on Mar 25, 2003 at 21:04 UTC
    He is using a combination of Win32::ODBC and DBI. $db->FetchRow and $db->Sql are Win32::ODBC. $dbh->do is DBI. I am sure using both together results in some weird interactions.

      I knew there was something mixed-up in that code, only I could not directly trace what it was.

      Thanks for pointing that out.

      CountZero

      "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law