Hmm ... I'll see what I can do then.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Database development questions? Check the forum!
>I tried that, but in Delphi with the particular component-set I'm using,
>this raises: mySQL Error Code: (1312)
>PROCEDURE test.p_Select() can't return a result set in the given context
Ah, you're not the first to have that error message, eg see the discussions at
Not sure which of those approaches will work for you.
Martijn Tonies wrote:
>CREATE PROCEDURE P_Select()
>READS SQL DATA
>select * from enum_table;
>How would I get a resultset?
No need for an OUT param, just call the sproc, you'll see.