2. PHPRunner General questions
  3. insert to another table after checkbox is checked
This topic is locked

insert to another table after checkbox is checked

 		4/7/2021 7:38:22 AM
PHPRunner General questions
author

I have table contain a field with lookup wizard and his properiies is checkbox list

i need code if I checked the checkbox make a copy of data to another table " i have 11 option for checkbox and i need if user select checkbox make a copy for another table " if select all copy to 11 tables "

please i need support

Regards
K
 		klyle 4/7/2021

I am looking into this right now as well. This topic seems to be the most relevant...https://xlinesoft.com/phprunner/docs/select_multiple_values_to_show_as_database_entries.htm
K
 		klyle 4/7/2021
K
 		klyle 4/7/2021
K
 		klyle 4/7/2021

I just did something similar based on a button click.

I know DAL is deprecated, but was looking for something that worked...which was adding this to a list.

global $dal;
$record = $button->getCurrentRecord();
// or the more modern $data = $pageObject->getCurrentRecord();
if ($record["PicklistTransactionMasterID"])
{
$sql = "INSERT INTO PicklistTransactionDetail ({Insert Field List Here}, PickListTransactionMasterID)
SELECT {Query Here}
HAVING {Blah Blah} ;

CustomQuery($sql);
$result["txt"] = "Details Inserted";

}

Probably better to not just blindly show the message, as well.

I would appreciate feedback.