Wolfe, Stephen S YA-02 6 MDSS/SGSI wrote: > <snip> > >> The one that most often bites me is inadvertently changing a field >> value, and then trying to move the record pointer without first >> > issuing > >> an update (and, sometimes, a requery()) Good luck - those messages >> drive me mad. I often give up and just rewrite it as a SPT :( >> > <snip> > > Vince care to expand on that a little bit more. Because I think this is > my problem. > > So, the order of table events should be: > > 1. Make modification to updateable field > 2. Do a TABLEUPDATE() > 3. The move record pointer > > Does that sound right? > Yes, although it's a lot easier to inadvertently move the pointer than you might realize, which is what bites me. eg, if you're on a record, and move to another page in a page frame that performs some sort of lookup on the same table in the Activate() method - that sort of thing. Also, just creating the record is a mod. HTH.
_______________________________________________ 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.
