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.

Reply via email to