On Tue, 20 Nov 2007, Alan McDonald wrote:

> > Using FB 2.0.3 on Gentoo, Qt 4.3.2
> >
> > I have a stored procedure that takes a number of input
> > parameters and a single
> > return value (which happens to be the Id of the record affected).
> >
> > I am calling this procedure using Qt QSqlQuery with the following SQL:
> >
> > execute procedure "AddFixtures" param1, param2, paramm3 etc
> >
> > The SP executes OK but I can't figure out how to get the
> > return value - I've
> > tried every combination I can think of based on the Qt help
> > information.
> >
> > Can someone please point me in the right direction?
> >
> > Regards
> > Tom Munro Glass
>
> Not knonwing Qt I will have to guess that it does not provide return values
> What you should use instead is a selectable SP call
> Eg.
> SELECT id FROM AddFixtures(param1, param2, paramm3);
> And use it in a normal query
> Alan
>

Thanks for the suggestion, but I've tried that and get the following error
when I try to read back the value:

QSqlQuery::value: not positioned on a valid record

Regards
Tom