>I renamed the variables in the PRG to no avail - I will cut & paste the code here in case I have missed something...
>
>if thisform.pgf_pages.page1.opt_merge.option1.value = 1
>lcDestination = 1
>else
>lcDestination = 2
>endif
>
>lcSql = "SELECT * FROM myTable INTO CURSOR temp"
>
>do merge_program with lcSql, lcDestination
>
>Now in the PRG
>
>LPARAMETERS tcSql, tcDest
>
>if tcDest = 1
>
>* destination is WORD
>
>* execute received SQL statement
>
>&tcSql
>else
>endif
>
>That's the gist
Well, I don't see anything wrong here except for parameters naming (if parameter is numeric, it would be logical to have it tnDest). May be you have couple of programs with the same name and the wrong one is executing? Put set step on after parameters statement and check in Debug, if they indeed correct.
If it's not broken, fix it until it is.
My Blog