nuBuilder Forum

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

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 ""

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:
but it seems that it is not working.

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

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

Janusz wrote: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.

.