Hi, To check for changements in your table one should 1) set mutlilocks on 2) open tabel with buffering 3) now you check, on leaving the form in queryunload and in release methods. Koen
2015-03-15 5:24 GMT+01:00 <[email protected]>: > In my form.load event: > > LOCAL loRec as Object > this.obiz.GetCompanyRecord(@loRec) > this.oStartingRecord = loRec > this.oRecord = loRec > > in my form.unload event: > SET STEP ON > IF NOT COMPOBJ(this.oStartingRecord,this.oRecord) THEN > IF this.obiz.ValidRecord(this.oRecord) THEN > IF MESSAGEBOX("Do you want to save your > changes?",4+32+0,"Save changes?") = 6 THEN > IF this.obiz.UpdateRecord(this. > oRecord.cID,this.oRecord,'luMyTable') THEN > DODEFAULT() > ELSE > this.ShowBizMsg() > ENDIF > ELSE > DODEFAULT() > ENDIF > ELSE > this.ShowBizMsg() > ENDIF > ELSE && no changes...just close > DODEFAULT() > ENDIF > > > This doesn't work, because it's sharing the same segment of memory, so any > changes to thisform.oRecord are also happening to > thisform.oStartingRecord. I did this successfully years ago, but > apparently I've forgotten something. > > What am I missing and/or doing wrong? It's gotta be something > small/simple I'm thinking. > > tia, > --Mike > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1StbwL7=8q3afwhe1eststoxsx8sptq2hg7w6dc-gay...@mail.gmail.com ** 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.

