Subject SOLVED - Re: [firebird-support] Getting return value from stored procedure using Qt QSqlQuery
Author Tom Munro Glass
On Tue, 20 Nov 2007, Peter Lee wrote:
> Hi Tom,
>
> After you call the exec() on the query, make sure you to a .next() or
> .first() to get onto the first record.... you can also check .isValid()
> after that to see if you've got a valid record at all.
>
> Regards,
>
> Peter Lee
>
> Alan McDonald wrote:
> >
> > You'll have to show us the SP source, maybe you are using exit instead of
> > SUSPEND
> > Alan
> >

I discovered that the SP has no SUSPEND statement and this has never been a
problem using Delphi/IBObjects - the SP has been working for years! But
calling it using the syntax:

> SELECT id FROM AddFixtures(param1, param2, param3);

requires the SUSPEND.

Thanks for the help guys.
Regards

Tom