Re: How to RESET @@session.error_count system variable

2006-07-13 Thread sheeri kritzer

As a session variable, it resets when you open a new session.

-Sheeri

On 6/21/06, Tony_10ph [EMAIL PROTECTED] wrote:


Hello guys... I have stored procedures and I want when a calling program call
my stored procedure it will return a response that the stored procedure
execute successfuly or return an error code to the calling program.
I found a @@session.error_count system variable but if theres an error this
variable store error count occur.  My problem is I can't RESET the value of
the @@session.error_count variable coz it says this is a read only variable.
Or is there any way functions I can use to handle error?.

Tony
--
View this message in context: 
http://www.nabble.com/How-to-RESET-%40%40session.error_count-system-variable-t1827840.html#a4986142
Sent from the MySQL - General forum at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



How to RESET @@session.error_count system variable

2006-06-21 Thread Tony_10ph

Hello guys... I have stored procedures and I want when a calling program call
my stored procedure it will return a response that the stored procedure
execute successfuly or return an error code to the calling program.  
I found a @@session.error_count system variable but if theres an error this
variable store error count occur.  My problem is I can't RESET the value of
the @@session.error_count variable coz it says this is a read only variable. 
Or is there any way functions I can use to handle error?.

Tony
--
View this message in context: 
http://www.nabble.com/How-to-RESET-%40%40session.error_count-system-variable-t1827840.html#a4986142
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]