hi,

im having trouble calling stored procedure..

sample code:
Qt Code:
  1. DELIMITER $$
  2.  
  3. DROP PROCEDURE IF EXISTS `rdmssql`.`hello`$$
  4. CREATE PROCEDURE `rdmssql`.`hello` ()
  5. BEGIN
  6.  
  7. SELECT * FROM RD0500;
  8.  
  9. END$$
  10.  
  11. DELIMITER ;
To copy to clipboard, switch view to plain text mode 

it my code
Qt Code:
  1. QSqlQuery sql("Call hello()");
  2. qDebug(sql.lastError().text());
To copy to clipboard, switch view to plain text mode 

but it return an error

PROCEDURE mydatabase.hello can't return a result set in the given context QMYSQL3: Unable to execute query
how to solve this?

im using Qt3.3.6 right now..
thanks.