> hi,
>
> I don't think you are alloow to use the "select * " syntax. I think you
> have to actually have a select list and place a suspend "loop" at the
> bottom of the query.
> I too am an sql server user and this drove me nuts when i first started
> using firebird.
> If you have IB EXPERT then you can script out the syntax of the sp from
> "sql editor"
>
>
> cheers
>
> martin.

take another look - IBExpert will actually create a select sp for you on the
table. You just tick/untick the fields you want. But select * from table
into :param1 is not as good as select field1, field2 etc

Alan