Re: DBI ignoring devide by zero

in reply to DBI ignoring devide by zero

Did you feed that sql script to a command line query tool? What does that query tool do? I fed it to Sybase's isql, and did not get an error there either. It's not DBI, it's the database ignoring the error. In general, do not execute more than one SQL statement at a time. If you do them one at a time, you do get an error.

Comment on Re: DBI ignoring devide by zero

Replies are listed 'Best First'.
Re^2: DBI ignoring devide by zero by emptyfull (Initiate) on Oct 02, 2012 at 13:42 UTC
its not DBMS for sure i tried same sql code with C++ and ODBC and i get error message i tried it with command line osql and i get Msg 8134, Level 16, State 1, Server FIENYSQL, Line 6 Divide by zero error encountered.	[reply]
Re^3: DBI ignoring devide by zero by Corion (Patriarch) on Oct 02, 2012 at 13:44 UTC
Do you check for errors? When creating the database connection, pass the `{ RaiseError => 1 }` attribute or do manual checks for errors whenever you run an SQL statement.	[reply] [d/l]

In Section Seekers of Perl Wisdom