David & Razzak, Many thanks for the help with this. I now have the resizing working with the property commands defined on buttons rather than using a DBNavigator control.
I had been trying to set the focus and/or move to the first rows for the regions in my EEP which wasn't firing and assuming that because the DBNavigator was linked to the table that it _effectively_ set that table as the currently active one. I can now press on with adding in adjusting the height of the form to match the size of the displayed regions. Regards, Alastair. ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 12, 2005 4:14 AM 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. >
