Subject Re: [firebird-support] Some questions
Author Martijn Tonies

> Hi, Im new in Firebird programming. I come from SQLServer2000.
> I like Firebir so much is more flexible, but I have some questions at this
> 1. How can I set the new value of an generator in an insert store
procedure to a return parameter.

myoutparam = gen_id(mygenerator, 1);

insert into mytable ... values (:myoutputparam, all other input parameters);

> 2. What about multiple querry select statements y an store procedure.
Looks like this feature not exists in firebird, wiil it be in future

You can do multiple selects - if you're asking for multiple (different)
resultsets to be returned from a procedure, then no, this cannot be done.

> Whit this feature a populate a .Net Dataset whith master a details tables
whit one store procedure in sql server.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions