Re: [Firebird-net-provider] Stored Procs and Singleton Select Statements

[Ben Hart]

On 03/01/06, Alejandro Perez <[EMAIL PROTECTED]> wrote:

If I remember correctly, what you should be adding a single suspend,
before the end of the stored procedure. I don't remember if it should
before or after the select's semicolon.

Excellent. Thanks, that works a treat. Changing the stored proc to:

begin
  SELECT AssetID,
         NAME
  FROM Asset
  WHERE Code = 'BHP'
  INTO  :AssetID,
        :Name;
  SUSPEND;
end

works perfectly. What confused me was that ibexpert etc., and isql could read it without the suspend, that the datareader had a fieldcount of 2 (so could interpret something), and that i could still get the first column by executescalar. But anyway, works great now, i'll roll the suspends in all over the place.

Thanks again,
Ben