Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to properly use cursor? 3
- Thread starter Mandy_crw
- Start date
-
1
- #2
Mike Lewis
Programmer
Once you have created a cursor, you can use it anywhere you like. It will be available in any form, or on any page of a pageframe, for as long as the cursor is open. You don't need to do anything special to achieve that.
(One exception to the above: you can only use the cursor in the data session in which it is created. But I doubt if that will be an issue for you, Mandy.)
And, yes, you can have three different cursors open at the same time - provided, of course, that they have different names.
Does that answer your question?
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
(One exception to the above: you can only use the cursor in the data session in which it is created. But I doubt if that will be an issue for you, Mandy.)
And, yes, you can have three different cursors open at the same time - provided, of course, that they have different names.
Does that answer your question?
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
- Thread starter
- #3
TamarGranor
Programmer
My experience is that "cannot access cursor" is an error you get from combos and lists when you've closed the table or cursor they're based on.
Tamar
Tamar
- Thread starter
- #5
Chris Miller
Programmer
It's easy to overlook that opening another table can close a table or cursor of the currently selected workarea. Which means, it can be an code that opens another table that accidentally closes the cursor the control still needs.
Chriss
Chriss
-
1
- #7
Chris Miller
Programmer
If you create a cursor in the Activate or Init event of a page, for example, you redo it again and again, and reusing the name would also be a reason you close the cursor at the same time you recreate it.
That's also the tricky part about repeated parts of a form UI, if you have a combobox for picking from a list stored in a table, for example, and need it in several places on a form, on several pages of a pageframe, using the same name means you also have the same selected record in all of them once a user picks an item in one of the comboboxes. To have separate picks you also need separate cursor names.
Chriss
That's also the tricky part about repeated parts of a form UI, if you have a combobox for picking from a list stored in a table, for example, and need it in several places on a form, on several pages of a pageframe, using the same name means you also have the same selected record in all of them once a user picks an item in one of the comboboxes. To have separate picks you also need separate cursor names.
Chriss
-
1
- #8
TamarGranor
Programmer
Use the Debugger to find out whether you've closed the relevant table/cursor. In the Watch window, put:
USED('TheAliasInQuestion')
and then double-click in the margin to set a breakpoint. You'll see a red dot there.
Then, when you run your code, the breakpoint will fire any time the value the relevant alias is opened or closed.
Tamar
USED('TheAliasInQuestion')
and then double-click in the margin to set a breakpoint. You'll see a red dot there.
Then, when you run your code, the breakpoint will fire any time the value the relevant alias is opened or closed.
Tamar
- Thread starter
- #9
- Status
