>>>Hi everybody,
>>>
>>>I have a form with a Record-Buffering table and a grid. I want to save data from one field for each current record. As I understand, it could be a form (or grid) property, say, cOldData. The question is: what's the best method for saving this olddata? The form has a navigation bar, which allows to move from record to record + user can navigate through grid itself.
>>>
>>>Thanks in advance.
>>
>>Update trigger ?
>>Cetin
>
>I don't understand your suggestion :( Besides, the table is not necessaryly the part of database, it could be a free table. For each current record I want to save an OldData. Could it be a method in the form? From where should it be called? It might be against n-tier design, but here we have just single tier application...
Free table :) OK.
If mdown()
lnBottom = .top+.headerheight+.relativerow * .rowheight
lnTop = lnBottom - this.rowheight
lnMouseRowPos = mrow(wontop(),3)
lnMouseColPos = mcol(wontop(),3)
llChangingRow = !(between(lnMouseRowPos,lnTop, lnBottom) ;
and between(lnMouseColPos,.left,.left+.width))
Else
llChangingRow = inlist(lastkey(),24,5,18,3,145,148)
Endif
If llChangingRow
If getfldstate('myField',this.Recordsource)%2=0
Wait window ;
'OLDVAL:'+nvl(oldval('myField',this.Recordsource),'')+chr(13)+;
'NEWVAL:'+nvl(eval(this.Recordsource+'.myField'),'')
Endif
Endif
Navigator buttons have something like Beforemove I think.
Cetin