>I have a routine which looks in a table and executes a program with its parameters.
>
>Therefore in my program I do the following:
>
>

>SELECT vwmprograms
>SEEK vwmmatch.actlinkno
>lcprogram = RTRIM(vwmprograms.program)
>lcparams = RTRIM(vwmprograms.params)
>DO &lcprogram WITH &lcparams
>

>
>The program runs but it fails because it cannot find one of the parameters. The problem is I think is to do with how it gets the parameters. For example some are hardcoded and some it has to find from another table. The parameters for this particular program stored in the field are:
>
>vwmevents.mainkey, vwmevents.udf1, "C1"
>
>Even though vwmevents table is open I dont think it can calculate the value of table fields.
>
>Can anybody help me please?

SELECT vwmprograms
SEEK vwmmatch.actlinkno
lcprogram = [DO ]+RTRIM(vwmprograms.program)+[ WITH ]+RTRIM(vwmprograms.params)
&lcprogram
*** OR
EXECSCRIPT(lcprogram)
** but for EXECSCRIPT all variables you used in that script and comes from somwhere else
** must be declare as PRIVATE or PUBLIC