Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!ucsd!swrinde!zaphod.mps.ohio-state.edu!samsung!uunet!zephyr.ens.tek.com!tektronix!sequent!lugnut From: lugnut@sequent.UUCP (Don Bolton) Newsgroups: comp.databases Subject: Re: Need help w/Informix 4gl forms Message-ID: <53027@sequent.UUCP> Date: 13 Feb 91 18:13:07 GMT References: <1991Feb12.220516.242@investor.pgh.pa.us> Reply-To: lugnut@sequent.UUCP (Don Bolton) Distribution: usa Organization: Sequent Computer Systems, Inc Lines: 42 In article <1991Feb12.220516.242@investor.pgh.pa.us> bwm@investor.pgh.pa.us (Bruce Miller #307) writes: >I am working with Informix 4gl v.1.10.00 and need some help with screen >forms. What I would like to do is to call a screen form using a program >variable rather than calling the form directly. > >I have a table with information on an individual and his stock broker (my >clients may be using any one of 40+ different brokers) and in the program >I call up a form that looks like the brokers confirm to make it easy for a >novice to get the required data (i.e. trade date not settlement date etc..). > >What I would like to be able to do is: > > open form ml from "pr_ar.broker" > options input wrap > display form ml > >where pr_ar.broker is a character variable that equals ML for example, and >I have a compiled form called ML.frm. However, as is obvious the program is >looking for pr_ar.broker not the value to which pr_ar.broker is set equal. > >I have tried using "$pr_ar.broker", and a few other things but to no avail. >Looking at the c-code generated hasn't been much help (but then again I >haven't much C programming background - except for reading a few texts) > >Any Help/Ideas would be appreciated! >-- >Bruce W. Miller (bwm@investor.pgh.pa.usa) >(412) 471-5320 work >(412) 731-4946 home Create a function to open form, I assume that you are storing some value in the parent row that will point you to the proper form in some fashion? in the open form function build a case on the field used to flag the desired form,,, Ie: WHEN pawnbroker = "joe" THEN OPEN FORM "X" FROM "/PATH/formname" WHEN pawnbroker = "bill" THEN OPEN FORM "Y" FROM "/PATH/formname" The sad thing here is that you will have a case to maintain, but it will do what you ask.