- Fri Sep 20, 2019 3:08 am
#826596
I have been struggling with this problem for a while now, and really neeed help.
I have these grids that i have to populate with a trigger.
This is a change process, so i allready have saved the record, just need to pull it up again, using a DNS name from PMT_ORDER_DATA as reference.
I use 2 pm tables :
ORDER_DATA_ITEM
ORDER_DATA The information i want to fill into the grid comes from ORDER_DATA_ITEM and i have to get it using a DNS name i get from ORDER_DATA
This is one of the version of the trigger code i have been trying, just to get any information into the grids.
The grid im trying to fill. The code im using to fill the text fields, its the DNS_name _Wanted i have to use in PMT_Order_Data :
I have these grids that i have to populate with a trigger.
This is a change process, so i allready have saved the record, just need to pull it up again, using a DNS name from PMT_ORDER_DATA as reference.
I use 2 pm tables :
ORDER_DATA_ITEM
ORDER_DATA The information i want to fill into the grid comes from ORDER_DATA_ITEM and i have to get it using a DNS name i get from ORDER_DATA
This is one of the version of the trigger code i have been trying, just to get any information into the grids.
Code: Select all
$linuxDiskManualTag = @@linuxDiskManualTag;
$result = executeQuery("select D1 AS $linuxDiskManualTag from PMT_ORDER_DATA_ITEM where OrderItemID = '190806_135951_27395034' and type =4");
putlog( 'SQL8='.$result );
if (is_array($result ) and count($result ) > 0) {
@@linuxDiskManualTagId = $result[1]['D1'];
}else{
$g = new G();
$g->SendMessageText("Could not select record in PMT_ORDER_DATA_ITEM PM table.", "ERROR");
The grid im trying to fill. The code im using to fill the text fields, its the DNS_name _Wanted i have to use in PMT_Order_Data :
Code: Select all
Greetings.$exitsting_DNS = @@exitsting_DNS;
$result = executeQuery("SELECT * FROM PMT_ORDER_DATA WHERE DNS_name_Wanted='$exitsting_DNS'");
if (is_array($result ) and count($result ) > 0) {
@@Sysowner_contact_name = $result [1]['SYSOWNER_CONTACT_NAME'];
@@Sysowner_department = $result [1]['SYSOWNER_DEPARTMENT'];
@@Sysowner_contact_phone = $result [1]['SYSOWNER_CONTACT_PHONE'];
@@Sysowner_manager= $result [1]['SYSOWNER_MANAGER'];
@@Sysowner_contact_email= $result [1]['SYSOWNER_CONTACT_EMAIL'];
@@Sysowner_mgr_phone= $result [1]['SYSOWNER_MGR_PHONE'];
}