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!