[RBG7-L] - Re: Firing an EEP on a multi-table form

[Dick Fey]

Sorry Astair... I mean regions, not grids.

Dick Fey

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" <rbg7-l@rbase.com>
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.