SQL Anywhere database - iSQL maximum Result Set windows/queries = 10 ?

Author

iSQL maximum Result Set windows/queries = 10 ?

handheldmaster

2005-10-27, 7:40 am

Recently upgraded from asa8 to asa9.0.2.3137

Had stored procedures that had > 10 select * queries that would print output in the result set window.. If I try the same with asa9 iSQL then it shows only the first 10 queries result set .. result set 1 to result set 10 .... Can this be increased ?

Looked up the Tools -> Options but could not find a place where this can be changed...

I do thave the show multiple result sets checked

Breck Carter [TeamSybase]

2005-10-27, 7:40 am

This is a new limitation. Please post a message in
product_futures_disc
ussion asking that the limit be increased.

Breck

On 24 Oct 2005 05:44:02 -0700, "handheldmaster" <abc@456.com> wrote:

>
>Recently upgraded from asa8 to asa9.0.2.3137
>
>Had stored procedures that had > 10 select * queries that would print output in the result set window.. If I try the same with asa9 iSQL then it shows only the first 10 queries result set .. result set 1 to result set 10 .... Can this be increased ?
>
>Looked up the Tools -> Options but could not find a place where this can be changed...
>
>I do thave the show multiple result sets checked

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links