Code Modification Required

[CWT]

I use a RAD called PHPRunner to build Database Applications.

One of the snippets of code I use a lot is to insert a Field Value from a Master Table into an equivalent Field in a Child Table as a "Before Add Event", is as follows: - 

global $dal;

$tblDetail = $dal->Table("tblUserRequests");

$tblDetail->Value["ID"] = $data["ID"];

$tblDetail->Param["ID"] = $data["ID"];

$tblDetail->Update();

unset($data["ID"]);

What I would like is help from someone to modify this code so that I can insert 2 or more Field Values in the same operation. So as well as inserting the Value "ID" into the Child Table I can also insert the Value "client". 

Many thanks for reading.

Carl. 

 

 

[ginerjm]

I think you would need to modify the Update function to achieve your wish.  What you are showing us is the setup steps only.  The Update function would need a change to accept a new parameter and a change to the query that gets run by Update to accomodate a new setup field.

Have at it!

[CWT]

Error handling is taken care of by my RAD.

I am merely seeking a derivation of the above to handle more than one value.

[ginerjm]

What are you saying?  Who is talking about 'error handling'?

If you want to do some change to accomodate an additional update to a record it sounds to me like the update function needs a change to handle that.

[cyberRobot]

@CWT - How familiar are you with coding in PHPRunner? It sounds like you need a loop (e.g., foreach, while). If you haven't worked with loops before, I'm sure there's some documentation you could look through.

Note that I haven't used PHPRunner before. So I don't have any specific code for you.

[CWT]

@cyberRobot Not very to be honest but thank you for suggestion I will explore that option. 

[CWT]

I have decided to pursue a different option utilizing Session Variables.