I am new to mydbr and am trying to learn about the CrossTab functionality.
I have successfully setup and executed several FilmList procedures and changes, but when I try to create a stored procedure for the CrossTab, I receive errors rom MySQL.
The Transcript of the MySQL commands follows;
[sql]mysql> delimiter ;;
mysql> create procedure sp_DBR_ProdXtab ()
-> select 'dbr.crosstab', 2;
-> select 'dbr.colstyle', 4, mydbr_style('Diff colors with bg');
-> select 'dbr.sum', 3,4,5;
-> select RepArea as 'Reporting area',
-> last_year as 'Last year',
-> this_year as 'This year',
-> next_year as 'Next year'
-> from mydb.ProductionSummary;
ERROR 1064 (42000): 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 ';
select 'dbr.colstyle', 4, mydbr_style('Diff colors with bg');
select 'dbr.sum' at line 2
mysql> delimiter ;
Any advice would be appreciated.