Cannot create MySQL stored procedure / views from Qt

[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.