Re: UPDATE not working with MS SQL Server

[keszler]

What does

my $sth = $dbh -> prepare("UPDATE vac_balance SET carry_over = ? WHERE
+ employee_id = ?") or die $dbh->errstr;
$sth -> execute($carry_over, $employee_id) or die $dbh->errstr;

say?

[Perobl]

I spotted my problem ... of course, after I posted here.

The code shared in my post is clean. The problem is in my SQL schema. There was a field name mismatch.

All is working fine now.

[johnny_carlos]

It's good practice to use the die statement, especially with databases, as it probably would have informed you of a bad column name.

[Eliya]

Or set RaiseError, which would make it die automatically in case of error...