Hello,
I am trying to do an update on an access table as follows:
my $update = qq!update PhonesSystems set Patch_panel = 'test' where ID = 1!;
if (!($odbc_db->Run("$update"))){
print "Error in $update\n";
($ErrNum, $ErrText, $ErrConn) = $db->Error();
print "ErrNum: $ErrNum ErrText: $ErrText ErrConn: $ErrCon\n";
print "Error: " . Win32::ODBC::DumpError() . "\n";
exit();
}
I am getting the following error:
Excecuting connection 1
sql statement: "update PhonesSystems set Patch_panel = 'test' where ID = 1"
Error: "-3030[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
cri
teria expression.10"
--------------------
I am trying to figure out the following:
1) which field is having the mismatch type problem - if it is that
2) If run does not happen it must return something other than zero because
my script keeps right on running - but then
how am I getting the return of the ErrorDump
Confused - any and all help would be appreciated.
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
