Thanks for confirming what I though Alastair's problem was, Razzak. One question: I haven't actually tried what you're suggesting: if my cursor is resting in a row of one of the regions (tables 2 - 4) of a multi-table form, and I click on a button that has:
PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' does that automatically jump the user from the current table back to table 1? David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, March 11, 2005 11:14 PM Subject: [RBG7-L] - Re: Firing an EEP on a multi-table form > > At 08:36 PM 3/11/2005, David Blocker wrote: > > >I belive this is the issue: if you are sitting in another > >table, and then click on the NEXT ROW in the navigataor > >control for TABLE 1, you are NOT asking for FOCUS to go to > >that table, and so I think R:Base will not fire the On Row > >Entry EEP. > > > >Razzak, am I understanding how On Row Entry works correctly? > > > David, > > I'll try to help you understand the logic. > > There MUST be a focus on the row of the actual table in order > for any EEP to do what it is supposed to do for that table. > > On Row Entry means "On_Row_Entry" and the focus on any column > is the simple way to explain the row entry. > > As you have explained above, how would you expect an EEP to > fire in TABLE 1 using DB Navigator (a focus-less control) > when the actual cursor and/or focus in entirely on a different > table? > > To achieve the desired results, here's how: > > 01. Define a "Custom DB Navigator" with embedded EEP to first > switch the focus on any column of the given table and then > use the NEXT ROW to fire the EEP. > > Example 01: (switch the focus and then change the row) > > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > PROPERTY TABLE <FormTableName> 'NEXT' -- for Next Row > > or > > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > PROPERTY TABLE <FormTableName> 'FIRST' -- for First Row > > or > > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > PROPERTY TABLE <FormTableName> 'PRIOR' -- for Previous Row > > or > > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > PROPERTY TABLE <FormTableName> 'LAST' -- for Last Row > > Example 02: (change the table row and then set the focus) > > PROPERTY TABLE <FormTableName> 'NEXT' -- for Next Row > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > > or > > PROPERTY TABLE <FormTableName> 'FIRST' -- for First Row > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > > or > > PROPERTY TABLE <FormTableName> 'PRIOR' -- for Previous Row > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > > or > > PROPERTY TABLE <FormTableName> 'LAST' -- for Last Row > PROPERTY <FirstTableColumnCompID> SET_FOCUS 'TRUE' > > That's all there is to it! > > Try that technique yourself and see what you find. > > For more TABLE PROPERTIES and examples take a look at the > latest R:Docs (version 2.1) released on 03/05/2005. > > Very Best R:egards, > > Razzak. > >
