OK, it sounds as if a Custom Form Action is the ticket here. You can key
it from multiple places using the syntax
PROPERTY RBASE_FORM_ACTION <Action Name> ' '
You can run it on entry and also on Row Entry in the MbrRegister table
and also on Tab Change. That should cover all your bets.
Albert
On 24/04/2013 1:08 PM, James Bentley wrote:
Albert,
Without exiting the form for a particular MbrNumber the user can tab
between panels and if a change was made a return to
a panel where they made changes need to reflect the updated status.
I don't think using ON AFTER START eep can handle that situation.
Jim Bentley,
American Celiac Society
1-504-737-3293
------------------------------------------------------------------------
*From:* Albert Berry <[email protected]>
*To:* RBASE-L Mailing List <[email protected]>
*Sent:* Wednesday, April 24, 2013 1:53 PM
*Subject:* [RBASE-L] - Re: Where to imbed eep commands?
I would go for the ON AFTER START eep for this code.
Albert
On 24/04/2013 12:51 PM, James Bentley wrote:
> Where to imbed eep commands?
>
> I have a form "EdMbrInformation"
> that contains multiple tabs as part of a Parent/Child
> table structure.
>
> Parent table "MbrRegister" linking key MbrNumber
> Subordinate tables:
> MbrCurHomeInfo
> MbrCurWorkInfo
> MbrEmailInfo
> MbrFaceBookInfo
> MbrLinkedInInfo
> MbrComment
>
> on each Panel Page there are six "bit" buttons
> Close
> Cancel
> Refresh
> Save
> Delete
> Add
>
> For any MbrNumber each of the Child Tables may contain
> 0,1, or many rows.
>
> Depending on whether the form mode is Enter/Edit/Browse
> certian buttons need to be ENABLED or disabled
> For example
> If the Child table contains 0 rows
> Disable the Delete Button
> Enable the Add Button
>
> I have devised the following code.
> ---
> SELECT COUNT(*) INTO FvMbrCmtCount FROM MbrCommentInfo WHERE
> MbrNumber=.FvMbrRegMbrNumber
> PROPERTY EGBMbrCmt_close ENABLED 'TRUE'
> PROPERTY EGBMbrCmt_cancel ENABLED 'TRUE'
> PROPERTY EGBMbrCmt_refresh ENABLED 'TRUE'
> SWITCH(.RBTI_FORM_MODE)
> CASE 'ENTER'
> PROPERTY EGBMbrCmt_save ENABLED 'TRUE'
> PROPERTY EGBMbrCmt_delete ENABLED 'FALSE'
> PROPERTY EGBMbrCmt_add ENABLED 'FALSE'
> BREAK
> CASE 'EDIT'
> PROPERTY EGBMbrCmt_save ENABLED 'TRUE'
> IF FvMbrCmtCount = 0 THEN
> PROPERTY EGBMbrCmt_delete ENABLED 'FALSE'
> PROPERTY EGBMbrCmt_add ENABLED 'TRUE'
> ELSE
> PROPERTY EGBMbrCmt_delete ENABLED 'TRUE'
> PROPERTY EGBMbrCmt_add ENABLED 'FALSE'
> ENDIF
> BREAK
> CASE 'BROWSE'
> PROPERTY EGBMbrCmt_refresh ENABLED 'FALSE'
> PROPERTY EGBMbrCmt_save ENABLED 'False'
> PROPERTY EGBMbrCmt_delete ENABLED 'False'
> PROPERTY EGBMbrCmt_add ENABLED 'FALSE'
> BREAK
> DEFAULT
> BREAK
> ENDSW
> RETURN
>
> My question is where should I embed the code?
> * Table: ON ROW ENTRY
> * Panel: ON TAB CHANGE
> * Other location(s)
> Jim Bentley,
> American Celiac Society
> 1-504-737-3293
> ------------------------------------------------------------------------
> **
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com <http://www.avg.com/>>
> Version: 2013.0.3272 / Virus Database: 3162/6270 - Release Date:
04/24/13
>
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.3272 / Virus Database: 3162/6270 - Release Date: 04/24/13
