Hi,

> Is it posible to have a stored procedure return a dataset ?
>
> A simpel ex. could be Select * from MyTable
>
> which should return 20 records.
>

Yes.

The procedure should have SUSPEND in it's loop.

And of course, some output parameters :)


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."