Andy Davies wrote: > Hi all, > well I'm back working with my ca based n-tier app and I'm having trouble > understanding the ca's cursor methods: > > autoopentables is set to true in my de but nodata is set in each ca so I > start with 'empty' cursors > > at various points in the code I determine the pk I want for each ca and > issue .cursorfill(.T., .F.) to fill 'em up. > > after changes to the data (which is in my 'scatter memo name this additive' > data object - but that's another story <g>) I do tableupdate and > .cursorrefresh() (not sure if that's necessary). > > after I've gone all through the logic I'm ready to start again - so I tried > doing .cursorfill(.T., .T.) to get 'no data' - but this seems to trash the > cursors:- > select mycursor falls over - > > so, what am I doing [particularly] wrong? How can I reset my data object? > (do I remember someone suggesting that you can zap cursors?...) > > I don't use CAs myself, but let me see if I understand you: are you trying to basically requery that cursor? If that's the case, shouldn't you just be doing a .cursorrefresh? And yes, you can zap cursors. I've done that where I have a local view, get some data in a different fashion, then zap the view and import the cursor data (for those "special circumstances" where a view isn't defined for a given something or other).
-- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
