>Hi Every:
> I have two cursors that I want to use. I don't want to use table because it creates a problem of deleting the table after the form closes. The problem is that when I open the second cursor, it closes the first one. How can I open two cursors in two different areas. This will solve the problem where the second cursor close the first one. Here is my code:
>
>***Code for first cursor
>Select * ; && select the data into the cursor
> From SqlResult ;
> Where recno() < 20;
> ORDER BY SqlResult.jobnum;
> InTo Cursor cAcct && first cursor
>
>***Code for second cursor
>Select * ; && select the data into the cursor
> From Jcjob;
> ORDER BY jcjob.jobAcct;
> InTo Cursor cJob && second cursor
>
>What happens is that when the second cursor (cJob) is open, it closes the first cursor (cAcct). How can I keep them both open.
>
>Thanks
>MA
This code should not close down any cursors. The second cursor will be the selected one, however.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only