Well, I guess that answers my question for Razzak - never mind Razzak. Very cool form, by the way, Alastair - VERY cool
And as always, great help Razzak! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 12, 2005 2:21 AM Subject: [RBG7-L] - Re: Firing an EEP on a multi-table form > 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. > > > >
