It's not *that* cryptic an error message... It's telling you that the call
to the procedure was looking for a result set, but none was found.
That means that the procedure probably returned prematurely, without
performing its final SELECT statement. Look for a RETURN statement, or a
conditional branch that might cause the logic to flow around that SELECT
statement.
Paul Horan[Sybase]
"Vollie Sanders" <vollie.sanders@norstan.com> wrote in message
news:48ce8bcd@forums-1-dub...
> we are upgrading several apps from PB10.3 to 11.2
> while testing the PB11.2 version of an app
> we encountered an error msg from the database
> that said the following-
> DataWindow Error
> ! Select Error: Requested result set number 1 not found.
>
> when we went back to the PB10.3 version and ran it,
> we got the following msg-
> DataWindow Error
> ! Select Error: SQLSTATE = 42000
> Microsoft OLE DB Provider for SQL Server
> Could not find stored procedure 'sp_sel_quote_detail_lbr_qty_01'.
>
> investigating we found that one of the developers had tried to
> modify this stored proc and it did not reload and they missed it.
>
> thats fine, we fixed it. my question is why the cryptic message from
> PB11.2 using the new OLEDB connection? even tried the new Native
> and it gave the same cryptic message. why it did not supply the name of
> the SP like previous OLEDB?
>
|