Hi I am using an application (excel) that sends sql requests and fills the excel sheet. When i issue an update statements, the update doesnt return data to my program (*.vba) in excel, so it hangs. To bypass the problem I was told to use the following ansi compliant sql statement "SET NOCOUNT ON" This way i can execute several select and update statements in the query and get one result back. The problem is that "SET NOCOUNT ON" is a mssql server command and not mysql. What should i do in mysql.. Please advise! Regards Geir --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php