"Barbara Deaton" <Barbara.Deaton@stripped> wrote on 12/01/2005 09:56:44 AM:
> All,
>
> I'm actually looking for a RTFM reply here. I need to simulate
> SQLSetPos and SQLBulkOperations in my application which is written
> with the MySQL C API. I thought MySQL 5.0 was supposed to have
> cursor support, but the only thing I can find in the documentation
> is regarding server side cursors via stored procedures.
>
> Are cursors supported outside of stored procedures, if so where can
> I find this information? I've googled "mysql cursor support" and
> they all take me back to the same place in the doc: 17.2.11. Cursors.
>
> Thanks for the information.
>
> -Barb.
>
Could the "HANDLER" set of commands work for your needs? I know it's not
the same but I offer it as an alternative.
http://dev.mysql.com/doc/refman/5.0/en/handler.html
AFAIK cursors are supported only within stored procedures AND functions.
Technically, that's a "yes" to your question. However I think you were
asking if you could have a cursor in a stand-alone SQL script and I
believe they cannot be exist in that environment, yet.
I am not sure how much effort it's going to be to enhance the user's
session to be able to host cursors just as a SPROC's session can but I am
pretty sure it's in the works already. Until then, your the CURSOR
commands will only function properly in PROCEDUREs or FUNCTIONs.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
