What do you mean, "..the second cursor close the first one.."? Is the first cursor still in use? Or you want to see the contents of both cursors on the form in the browse-like windows?
>>>>>>>>>>>>>Your message below
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
Previous
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