>Hi,
>
>I'm doing the following:
>
>select * from sometable into cursor myCursor
>
>do some code
>
>select * from myCursor where some_logic into cursor myCursor
>
>the above works for 17 times - but not on 18th. Notice I'm selecting from the temp cursor into its self
>
>I got this trick from UI and I was wondering if anybody knew how many times I can do this. Is 18 the limit?? I thought there was no limit?
>John

SELECT - SQL may create a filtered result set rather than an actual disk file, especially for simple queries. If you are going to do repeated operations on the resultant cursor, you should make sure a disk file results by using the NOFILTER clause:

select * from sometable into cursor myCursor <b>NoFilter</b>