[freetds] Testing for query success
James Vanns
jimv at canterbury.ac.uk
Wed Jan 12 06:02:55 EST 2005
Dear all,
First a happy new year to you. Now, to the point! I am issuing an UPDATE
statement (actually I am calling a stored procedure that issues this
statement) against a Microsoft SQL Server (2000).
I am testing this using sqsh also...
Basically, this SP succeeds yet I also get an error message returned
(not a record set):
'Arithmetic overflow error converting expression to data type
datetime.The statement has been terminated.'
As I said - the update succeeds and the date format is accepted and
stored fine (format was: 2003-04-11 17:29:27).
So
a) Why is this message returned by FreeTDS?
b) If this error message is returned how come the SQSH (and therefore
FreeTDS?) program prints '(return status = 0)' also? Doesn't 0 signify
success?
Any direction you can give me to the solution to this will be
appreciated. I.e. what dblib or even tds functions should I be calling
to test for the real success or failure of my statement?
Regards
Jim Vanns
PS: This is FreeTDS 0.62
--
James Vanns BSc (Hons) MCP
Linux Systems Administrator
Software Engineer (Linux / C & C++)
Canterbury Christ Church University College
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370
More information about the FreeTDS
mailing list