On Wed, Jun 30, 2010 at 6:29 AM, Rafael Copquin <[email protected]> wrote: > In the olden days of VFP 6 I used to save the cursor to disk and then > open it in the called form. > But this is not always adequate. > > BTW, I always use private data session forms, especially when certain > properties are changed in the second form that would affect the same > properties in the first form. With XML you can pass a cursor to another > form, you can save this cursor in a memo field and then retrieve it for > further use. > > I can give you an example of the latter: > > I built a budgeting system where the user "builds a picture" of the > financial situation at one point in time, including certain expenses. He > then saves the cursor into a memo field in a special table, as xml. Then > he builds another picture, including or excluding certain expenses, > which is saved as xml in the same table, but in a new record. And so on. > He can then pull the different versions, at a a later time, transforming > them from the saved xml into cursors, to be shown in a grid, printed, > sent to Excel through automation for further manipulation, etc. -----------------------
Sounds like my audit system for all data changes. Row contains userID, datetime, textBefore, textAfter, dataClass, action, textParams If you open a form with data I will record what you are looking at. The dataClass helps us load the actual data into a container from the columns textBefore/After. I don't register report data pulls in this manner. Action shows me the letter in CRUD operations, textParmas are any that you presented. All "text" columns are going to contain XML. When people want an audit of activity it is all based around an operator so that is searchable. After that you get all of the content that they were doing within a set of dates if you cared. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
