hi,
im having trouble calling stored procedure..
sample code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `rdmssql`.`hello`$$
CREATE PROCEDURE `rdmssql`.`hello` ()
BEGIN
SELECT * FROM RD0500;
END$$
DELIMITER ;
DELIMITER $$
DROP PROCEDURE IF EXISTS `rdmssql`.`hello`$$
CREATE PROCEDURE `rdmssql`.`hello` ()
BEGIN
SELECT * FROM RD0500;
END$$
DELIMITER ;
To copy to clipboard, switch view to plain text mode
it my code
qDebug(sql.lastError().text());
QSqlQuery sql("Call hello()");
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.
Bookmarks