Alastair, Jan, Javier and Dr. Razzak, For what its worth, I found a solution that is very simple.
Going in and out of the field from the left or right works as predicted using an On Entry EEP to get the starting value with GETPROPERTY and On Exit EEP to get the new value. The hard part for me was when I would enter the field from above or below using F7 or F8. The solution...... The field (or column) in the table/scrolling region is called shortcut. In the form variables, I added the expression vshortcut = shortcut Then I used an On Row entry this tiny bit of code.... --On Row Entry SET VAR vshortcut0 = .vshortcut RETURN --On Exit EEP GETPROPERTY id_shortcut TEXTVALUE vshortcut1 IF vshortcut0 <> .vshortcut1 THEN --run my code ELSE GOTO end ENDIF LABEL end RETURN By doing so, the On Row Entry EEP captures the original value of the field in the new row I don't know if I have found a bug or I just don't understand what is supposed to happen, but the On Row Entry EEP does not appear to capture the value of the new row using a GETPROPERTY command, it appears to capture the value of the field that it is coming from. I would like somebody else to confirm this, or educate me if I am understanding the way it is supposed to work. Mike ________________________________ From: Alastair Burr <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, June 19, 2012 1:17:15 PM Subject: [RBASE-L] - RE: On Row Entry EEP with mouse click vs [F7]/[F8] Mike, There must be other and perhaps simpler ways but the first thing that came to my mind was to use a temp table to store the value of the row that you are leaving. If you want to then you can save any number of values/rows by using two columns with the key in one and the value in the other column. Just an idea – might be useless – but temp tables can be magic!! Regards, Alastair. From: Michael J. Sinclair Sent: Tuesday, June 19, 2012 2:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: On Row Entry EEP with mouse click vs [F7]/[F8] Jan, Do you recall what you did? I am thinking that a combination of using the lastkey function to see if I got to the field via a tab or return vs an F7/F8 and then doing the comparison based on values obtained with form system variables or getproperty or using a form variable would do the trick, but I have not been able to figure it out yet. I can understand that F7 and F8 are not really changing the field, but I would think that the On Entry Row EEP would capture the "new row" value and the On Exit Row EEP would capture the "old row" value, but that does not seem to be the case. Mike ________________________________ From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, June 19, 2012 8:53:39 AM Subject: [RBASE-L] - RE: On Row Entry EEP with mouse click vs [F7]/[F8] Mike, That is due to the nature of the scrolling region. Technically you are not leaving the field when you switch rows. This point has been debated for years on this list. I had to do some creative EEPing to kind of do what you want. That was in the past and I have moved away from scrolling regions. My preferred tool is now the variable listview. Jan -----Original Message----- >From: "Michael J. Sinclair" <[email protected]> >To: [email protected] (RBASE-L Mailing List) >Date: Tue, 19 Jun 2012 05:17:00 -0700 (PDT) >Subject: [RBASE-L] - RE: On Row Entry EEP with mouse click vs [F7]/[F8] > > >Javier, >You sure made that part simple! What I am actually trying to do is to check to >see if the value in the field changes. If it does, I want my On Exit EEP to >fire, if not, I don't want the On Exit EEP to fire. How can I capture value >when >I enter the field and then see if it has changed? It is easy to do that when I >am moving back and forth between fields within a row, but I am having trouble >doing it when I am moving back and forth between rows within the same field >when >I use the [F7] and [F8] keys. >Mike > > > ________________________________ From: Javier Valencia <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Tue, June 19, 2012 12:44:26 AM >Subject: [RBASE-L] - RE: On Row Entry EEP with mouse click vs [F7]/[F8] > > >Mike, > >There is the old school, simpler way. Go to the top menu>>Variables>>Add/Edit >Variable and create a variable, say vWhatever equal to the column whose value >you want to collect. This variable will have the value of the column for the >current record, regardless of how you get there. With the advent of the >Property >command, sometimes we forget that the simple things still work. > >Javier, > >Javier Valencia, PE >O: 913-829-0888 >H: 913-397-9605 >C: 913-915-3137 > >From:[email protected] [mailto:[email protected]] On Behalf Of Michael J. >Sinclair >Sent: Monday, June 18, 2012 10:44 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - On Row Entry EEP with mouse click vs [F7]/[F8] > >Hello all, >I have a form with a scrolling region. >As I move from row to row within the same field, I would like to capture the >value of the field that I am going to. If I use the On Row Entry EEP, and I >move >from one row to the next using my mouse, the EEP seems to work just fine. BUT >if >I use the [F7] or [F8] key to move from one row to the next, the On Row Entry >EEP captures the value of the field I am leaving. The On Row Entry EEP I have >is >pretty simple... > >GETPROPERTY component_id TEXTVALUE varname >RETURN > >Is there a way to capture the value of the field I am going to using the [F7] >or >[F8] key? Should there be a difference between jumping from one row to another >using a mouse click vs the [F7] or [F8] key? > >Thanks >Mike >
