Hi,

> 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

moment.

>
> 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
versions?


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
Server.
Upscene Productions
http://www.upscene.com