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?