- Mon Jul 08, 2019 11:35 am
#825313
Hello,
I'm exeperiencing and issue when loading a Form with a SQL statement from PM database. In this form I have a grid with a DropDown loaded with the departments:
[SELECT CON_ID, CON_VALUE FROM CONTENT WHERE CON_CATEGORY='DEPO_TITLE'
AND CON_LANG = @@SYS_LANG
AND CON_ID NOT IN ("7405700685b864cf8efba20081648989", "4685363765b864e003c7ef4099718443", "1815795895b864e13a30438030841764", "8353271485b8651f410efe5000584241")
ORDER BY CON_VALUE]
and another dependent DropDown with the equipment on the selected department.
When I want to access this "entity", I have a trigger with a SQL to select the values, including the Department:
(The first grid row is how should be - become like that after I click over the dropdownw!!) The both rows appear like the second.
Any tip about what is happening?
Thanks.
I'm exeperiencing and issue when loading a Form with a SQL statement from PM database. In this form I have a grid with a DropDown loaded with the departments:
[SELECT CON_ID, CON_VALUE FROM CONTENT WHERE CON_CATEGORY='DEPO_TITLE'
AND CON_LANG = @@SYS_LANG
AND CON_ID NOT IN ("7405700685b864cf8efba20081648989", "4685363765b864e003c7ef4099718443", "1815795895b864e13a30438030841764", "8353271485b8651f410efe5000584241")
ORDER BY CON_VALUE]
and another dependent DropDown with the equipment on the selected department.
When I want to access this "entity", I have a trigger with a SQL to select the values, including the Department:
Code: Select all
But the form renders with this image:$var = @@SerialNumber;
$var1 = @@CustomerID;
$result = executeQuery( "SELECT * FROM PMT_CUSTOMER_MI WHERE SERIALNUMBER = '$var' AND APP_STATUS = 'COMPLETED' AND
CUSTOMERID = '$var1' ORDER BY APP_NUMBER DESC LIMIT 1");
if (is_array($result) and count($result) > 0) {
@@CalibrationLast = $result[1]['CALIBRATIONLAST'];
@@CalibrationNext = $result[1]['CALIBRATIONNEXT'];
@@CalibrationProcedure = $result[1]['CALIBRATIONPROCEDURE'];
@@RecalibrationInterval = $result[1]['RECALIBRATIONINTERVAL'];
@%Category = $result[1]['CATEGORY'];
@@Manufacturer = $result[1]['MANUFACTURER'];
@@MeasuringQty = $result[1]['MEASURINGQTY'];
@@Name = $result[1]['NAME'];
@@RangeInterval = $result[1]['RANGEINTERVAL'];
@@Remark = $result[1]['REMARK'];
@@SoftwareIncluded = $result[1]['SOFTWAREINCLUDED'];
@@Status = $result[1]['STATUS'];
@@Validity = $result[1]['VALIDITY'];
@@YearProduction = $result[1]['YEARPRODUCTION'];
@@YearStart = $result[1]['YEARSTART'];
@@TypeApprovalNumber = $result[1]['TYPEAPPROVALNUMBER'];
@@DateCreated = $result[1]['DATECREATED'];
@@Accessories = $result[1]['ACCESSORIES'];
@=Documentation = $result[1]['DOCUMENTATION'];
@@AccuracyClass = $result[1]['ACCURACYCLASS'];
@@MiID = $result[1]['MIID'];
@@Model = $result[1]['MODEL'];
@@OldAppNumber = $result[1]['APP_UID'];
}
//lOAD GRID OF REFERENCE STANDARDS
$miid = @@MiID;
//This query loads the DropDown with pre-saved values
$query = "SELECT DIVISIONID AS DivisionID, REFSTD as RefStd, CUSTOMERMIID AS CustomerMiID
FROM PMT_CUSTOMER_MI_REFSTD WHERE CUSTOMERMIID='$miid'";
$result = executeQuery($query);
if (is_array($result) and count($result) > 0)
@=gridRefStd = $result;
(The first grid row is how should be - become like that after I click over the dropdownw!!) The both rows appear like the second.
Any tip about what is happening?
Thanks.
Attachments
issue.PNG (12.71 KiB) Viewed 5550 times