I have a map that has a source where I pass a variable -ID -VAR pwknbr=dbfield.
I am trying to do a run map on this map. I can do =RUN ("mymap.mmc", "-OE1" ) and I get the output of the map, but I need to override the input parm. Listed below is what I have tried without success. I've gotten a RC of 12 for it -- which I haven't found.
=RUN ("mymap.mmc", " -ID1 '-ID -VAR pwknbr=dbfield' " + "-OE1" )
Any help is appreciated.
J
Run map -- passing database variable
did get it to work
I did finally get this to work. Had to do with getting the tick marks correct. One really good tip I got on that is to include the appropriate ticks in the query when setting it up in Db Interface Designer. Then, I don't have to worry about the ticks when passing variables.