Subject Re: [firebird-support] Pulling my hair out..
Author Helen Borrie
At 07:37 a.m. 13/04/2014, Gordon Hamm wrote:

>BTW, I took the code out, and made a simple query.. I stripped it down to nothing, and gives me an error of..
>"No current record for fetch operation"

That suggests that you are trying to run this stored proc using EXECUTE PROCEDURE, which would return nulls to a dataset.

Your procedure is written as a SELECT procedure so to get a result into the dataset prepared by IBExpert you need

select product, si_rec_id from inventory_proc

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"