I'm using Win32::ODBC and trying to insert a record into an access
database.
This is the error I'm getting.
SQL failed. Error: [-3035] [1] [0] "[Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query."
and this is the code I'm using
#Opening database
if (!($db = new Win32::ODBC($DSN))){
print "Error connecting to $DSN\n";
print "Error: " . Win32::ODBC::Error() . "\n";
exit;
}
$SqlStatement = "INSERT INTO project (projectid,name,startdate,status)
values ($projnum,'$fields{prjname}',$fields{startdate},$status)";
if ($db->Sql($SqlStatement)){
print "SQL failed.\n";
print "Error: " . $db->Error() . "\n";
$db->Close();
exit;
}
#Closing database
$db->Close();
what is wrong with this code, it works great for doing queries.