>thanks, I better change my code.
>
>I also have another code:
>
>SELECT * FROM MyTable ;
> INTO CURSOR abcdzzz
>select abcdzzz
The second command is superfluous: the SELECT ... INTO CURSOR will automatically select the newly-created cursor.
By the way, to show code with proper indenting (in UT messages), use the HTML command < PRE >. Press "Reply" to see how I wrote the following:
select * from MyTable;
into cursor abcdzzz
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)