Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing a value to a PRG with PARAMETERS
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00583456
Message ID:
00583519
Views:
28
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform