Cannot create MySQL stored procedure / views from Qt

[pshah.mumbai]

//Main program
int main(int argc, char *argv[])
{
	QApplication app(argc, argv);
	QSqlDatabase db;
	db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("localhost");
	db.setUserName("root");
	db.setPassword("root");
	db.setDatabaseName("test");
	if(db.open())
	{
		QString create_tables_sql;
 
create_tables_sql = "DELIMITER $$ \n\
CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END $$ \n\
DELIMITER ; ";
 
		qDebug() << create_tables_sql;
		QSqlQuery me;	
		if (!me.exec(create_tables_sql))
		{
			qDebug() << "Query exec problem";
;		}
		qDebug() << me.lastError();	//QSqlError(-1, "", "")
		exit(1);
	}
	else
	{
		qDebug() << "Db not open";
		exit(1);
	}
 
	return app.exec();
}

//Main program
int main(int argc, char *argv[])
{
	QApplication app(argc, argv);
	QSqlDatabase db;
	db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("localhost");
	db.setUserName("root");
	db.setPassword("root");
	db.setDatabaseName("test");
	if(db.open())
	{
		QString create_tables_sql;

create_tables_sql = "DELIMITER $$ \n\
CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END $$ \n\
DELIMITER ; ";

		qDebug() << create_tables_sql;
		QSqlQuery me;	
		if (!me.exec(create_tables_sql))
		{
			qDebug() << "Query exec problem";
;		}
		qDebug() << me.lastError();	//QSqlError(-1, "", "")
		exit(1);
	}
	else
	{
		qDebug() << "Db not open";
		exit(1);
	}

	return app.exec();
}

To copy to clipboard, switch view to plain text mode 

Query exec problem
QSqlError(1064, "QMYSQL: Unable to execute query", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
CREATE PROCEDURE Fun()
BEGIN
SELECT * FROM test;
END $$
DELIMI' at line 1")

[pshah.mumbai]

Now it seems to work when I remove the delimiter statements.

I will test it more and report back

[pshah.mumbai]

here is the code.

QString create_tables_sql;
 
create_tables_sql = "CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END";
 
qDebug() << create_tables_sql;
QSqlQuery me;	
if (!me.exec(create_tables_sql))
{
	qDebug() << "Query exec problem";
}

QString create_tables_sql;

create_tables_sql = "CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END";

qDebug() << create_tables_sql;
QSqlQuery me;	
if (!me.exec(create_tables_sql))
{
	qDebug() << "Query exec problem";
}

To copy to clipboard, switch view to plain text mode 

[pshah.mumbai]

Its working perfectly now.

1. Do not use the DELIMTER statements

QString procedure = "CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END ;";
 
me.exec(procedure);

QString procedure = "CREATE PROCEDURE Fun() \n\
BEGIN \n\
SELECT * FROM test; \n\
END ;";

me.exec(procedure);

To copy to clipboard, switch view to plain text mode 

2. Do not call drop procedure in the same query.