2. PHPRunner General questions
  3. Hints to do this
This topic is locked

Hints to do this

 		7/7/2019 9:34:46 AM
PHPRunner General questions
R
 rubenbalde author

Hi, buddies,
I need to call store procedure with a paremeter request to the user. How is the best option to do accomplish this scenary:

  1. User push a button from a list
  2. a popup appear he input the parameter
  3. I call the sp
  4. I refresh the list.
    TIA
    Walter
jadachDevClub member 7/7/2019

I would create a simple table called SPExecuted. In that table put the field you want for the parameter. I would also include added by (who ran the SP) and added (when it was run).
Now on your list page, create a popup to an add page based on the SPExecuted table. In the before record added or after record added event, run your SP passing the parameter. Now you have a running record of the executions and who did it and the parameter values sent.
rdsanford 7/8/2019



I would create a simple table called SPExecuted. In that table put the field you want for the parameter. I would also include added by (who ran the SP) and added (when it was run).
Now on your list page, create a popup to an add page based on the SPExecuted table. In the before record added or after record added event, run your SP passing the parameter. Now you have a running record of the executions and who did it and the parameter values sent.


Yes! Excellent timing and response. I had a similar question. I need to pass 6 parameters to a sproc and also record the parameters sent. Worked perfectly! Thanks
R
 		rubenbalde author 7/25/2019



I would create a simple table called SPExecuted. In that table put the field you want for the parameter. I would also include added by (who ran the SP) and added (when it was run).
Now on your list page, create a popup to an add page based on the SPExecuted table. In the before record added or after record added event, run your SP passing the parameter. Now you have a running record of the executions and who did it and the parameter values sent.


Hi,
Great solution! I tried it but I can't close te popup (it still open and redirect to welcome page) could you share the code to open, run, close an refresh the list? TIA
Walter