Hello,
I'm trying to write a program that will update a
simple Access 2000 table. Whenever I try to run the
insert statement, though, I get the following error
back:
"
DBD::ODBC::st execute failed: [Microsoft][ODBC
Microsoft Access Driver] Operation must use an
updateable query.
(SQL-S1000)(DBD:st_execute/SQLExecute err=-1) at
dbi_ins_test.pl line 56.
"
This is what the prepared statement looks like:
"
my $sth5 = $dbh->prepare("insert into dbi_test
( district_cd ) values (?)")
or die "Cant prepare jcdb insert" . $dbh->errstr;
"
...and the execute part looks like:
"
$sth5->execute( $district_cd )
or die "Can\'t insert new records: " . $dbh->errstr;
"
Before this, I bound $district_cd to a column from
another query. I checked, and $district_cd is getting
the value it's supposed to.
I've looked all over the place to figure out what
Access means by "updateable query". In the help files
it says it means I'm trying to update to a special
field of some kind, but I am certain that I am not. I
even tried their "Knowledge Base" with the same
result.
I know this isn't coming from perl or the dbi module,
but has anyone run into this kind of problem before
with Access? I'd appeciate any help, as I am banging
my head against a wall at this point.
Thanks,
Alan
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
