2. PHPRunner General questions
  3. Execute 2 SQL queries dependending on user answer
This topic is locked

Execute 2 SQL queries dependending on user answer

 		6/2/2021 4:15:42 PM
PHPRunner General questions
P
 Prof_Moriarti author

Hello all:
I would like to execute 2 different sql queries depending on a user question.
And i dont know if its possible and how to do it

Thxs
admin 6/3/2021

What version of PHPRunner is this? Where, when and how do you need to ask this question?

P
 		Prof_Moriarti author 6/3/2021

version 10.5 (37167x64)

What i would like is that for example
Before a record is saved. Ask the user a question (giving 3 options)
For example
A) delete
B) insert
c) update
And with the $values data build a sql query and execute the option selected by the user.
admin 6/5/2021

It makes sense. I would suggest using Dialog API for this purpose.

And this is how you can ask this question before record is saved.