Execute SQL on button click

[fpdragon]

Hello,

I'm fighting with a pretty easy task.

In the edit screen of an item, I want to add a button that does some SQL stuff. (duplaction of the current item + some modifications...) I already have working SQL code.
First I thought: easy. I just have to add an Object and configure it as "Run" button and select a previously added SQL. But it is not possible to select any SQL from a run button.
Then I tried to add a PHP Procedure and used the "nuRunQuery" function to execute every SQL line step by step. But also here I can't select the procedure from the "Run" reference selector.

I hope somebody can help.

BR

[fpdragon]

Seems that I found out why the new php procedure was not shown in the selector.

zzzzsys_php.sph_run must not be NULL but ""
and
zzzzsys_php.sph_system must not be NULL but ""

[fpdragon]

Now I have the next problem that I need to get the id of the current element and use it in the SQL.

First I thought of something like this:

Code: Select all

nuRunQuery("CREATE TEMPORARY TABLE `_copy_table_temp` SELECT * FROM `dl_projects` WHERE `dl_projects_id` = '".nuLookupRecord()->dl_projects_id."';");

but it seems that it is not working.

[fpdragon]

Maybe the "Filter" or the "Record ID" fields can be used somehow from the Run object?

[Janusz]

If you want to read the code from the Lookup object on the current form just use in the php:

Code: Select all

$x=('#ID_of_the_object#');

and

Code: Select all

.... WHERE par_number='$x';";  //for string
or
.... WHERE con_part=$x;";     //for int

[fpdragon]

If you want to read the code from the Lookup object on the current form just use in the php:

Code: Select all

$x=('#ID_of_the_object#');

and

Code: Select all

.... WHERE par_number='$x';";  //for string
or
.... WHERE con_part=$x;";     //for int

Thank you very much.

It works.

[admin]

.