Page 1 of 1

Run map -- passing database variable

Posted: Thu Jan 19, 2006 9:02 am
by jlpa
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

Posted: Tue Jan 31, 2006 3:13 am
by janhess
=RUN ("mymap.mmc", " -ID1 '-VAR pwknbr=dbfield' " + "-OE1" )

did get it to work

Posted: Thu Apr 20, 2006 12:15 pm
by jlpa
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.