Subject | SOLVED - Re: [firebird-support] Getting return value from stored procedure using Qt QSqlQuery |
---|---|
Author | Tom Munro Glass |
Post date | 2007-11-20T03:53Z |
On Tue, 20 Nov 2007, Peter Lee wrote:
problem using Delphi/IBObjects - the SP has been working for years! But
calling it using the syntax:
Thanks for the help guys.
Regards
Tom
> Hi Tom,I discovered that the SP has no SUSPEND statement and this has never been a
>
> 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
> >
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