I have the same drop down list box on about 25 forms. Currently, I have a quickevent tied to the drop down that calls a stored procedure. I want to change the quick event to call a different stored procedure for the control on each of the 25 forms.

Is there any way to update the quick event tied to the control programatically, without having to open each form, change the procedure being called, and saving the form?

TIA.

Gene

Well .. you can wrap a shell around it and then call different stored procedures based on the name of the form:

DECLARE SUBROUTINE DOIT(PARAM)

Declare Function Get_Property

WIN_NAME=@WINDOW

Begin Case

Case Win_Name=XB57D' ; CALL XB57D_PROC

Case Win_name=WHATSIT' ; CALL WHATSIT_PROC

End CASE

Return

Is this what you're after?

Don Miller

C3 Inc.

Don,

I want to update the stored procedure being called from the control on each of the forms to a new one, without having to manually go into each form, open the quickevent for the control, select the new stored procedure to call, and enter the subroutine to fire from the procedure.

Example: Forms 1-25, EMP_NO dropdown with a dropdown quickevent that calls procedure a, paramater b. I want to change all to call procedure c, paramater d.

This assumes that there is a table relationship between the forms, the controls on the forms, and the quick events tied to the controls on the forms…?

Any thoughts?

Gene

Well Gene .. the shell get just a little more complicated:

SUBROUTINE SHELL(PARM)

Declare FUNCTION Get_Property..whetever else you need

Win=Get_Property(@WINDOW…..)

Where=Get_Property(ctlentid…..) ;* this will be fully qualified

Thingie=Field(where,'.',2) ;* this will have the control name

Begin Case

..as bizarre as you want for example if you named all controls

that get employees EE_NUM and you want to do a popup every time

then

Case Thingie=EE_NUM'

Do your popup or what you will and put the result in Retval

SET_PROPERTY(CTRLENTID,"TEXT",Retval)

End Case

Return

Remember to order your case processing logic properly since the first thing that gets a hit does its thing and nothing below it will be processed. However, if you have global events which use the same control in a lot of forms then this will work fine

Good Luck

Don Miller

C3 Inc.

Don,

The shell approach as outlined will do the trick.

Thanks for your help.

Gene

View this thread on the forum...