>IN VFP6
>I create a temporary cursor in the load of a form. I have a grid that will display this cursor on one of my pages. To input data in this cursor I manipulate two different tables into this cursor. Off this form I have the ability of choosing another agent. at this time I need to clear out all the data in the cursor and start again for the new agent. I tried ZAP but was told this command can not be issued on a table with cursors in table buffering mode. I tried CLEAR RESOURSES feetable (where feetable is the name of my cursor) but it did not clear out the cursor it just keeps adding to the existing records. What should I be using to clear the cursor out. Do I need to close it and create it everytime?
>Thanks for the help!
The short answer is "yes". But, if what you are really trying to do is prevent the grid properties from being messed up when the data source changes, there are two options. One is to use a parameterized local view instead of a dynamically-built cursor (that way you simply REQUERY() the view when it is time to pick a new agent. The other way would be to define the grid with all of the properties set the way you want them as a separate class, so that it can be rebuilt after the cursor has been closed and reopened.
Hope that helps.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.