Re: Cursor Problem

[Malcolm Needham]

Rama - did you ever get it figured out. I am having a similar problem on version 5.0.67. MySQL doesn't like this:

DECLARE cur1 CURSOR FOR SELECT * FROM work_flights ;

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 'DECLARE cur1 CURSOR FOR SELECT * FROM work_flights' at line 1

I can't get it to take ANY cursor declarations.