We recently upgraded from a year-old+ version of PL to 5.1.2. The Atrium database changed and we had to change our code that populates it with menus, but otherwise things worked correctly, or seemed to. But now the select box dropdowns won't populate from the database, which is otherwise accessed correctly. In the select box we have
choices database file CSVLLSP
choices options field (CASE SUBSTR(INTVAL,1,1) WHEN ' ' THEN ''' ''' ELSE INTVAL END) || ':' || CNDTXT
choices values field INTVAL
choices selection criteria @@CND=1103585 and CNDTYP='VAL'
This no longer works. produces an empty dropdown. The database is accessed correctly, for example, when displaying a master table of records, and clicking thru to the detail.
There is nothing obvious in the change logs. Any suggestions? Thanks
All you've really told us is that the drop-down is blank. The properties are interesting, but I cannot try them, as I do not have your database tables on my system.
Please tell us:
1) What is the SQL statement that Profound UI is generating. You can find this by looking in the PUISSNVP file while your screen is running. You may have to page through the file to find it, but the SQL statement will be in there.
2) What error message you are getting. This can be found in the HTTP response in your browser's web tools. Or you can use the showErrors() API or the pui.showLastError() API to see the errors in a popup.
Thanks. PROFOUNDUI/PUISSNVP has records with 3 fields, session id, name and value, not an SQL stmt. The name on the last record is "genie.I_21_64" which is the genie id of the last select box on the page. The value is 32002.
genie?skin=VG_Base:1 This page includes a password or credit card input in a non-secure context. A warning has been added to the URL bar. For more information, see https://goo.gl/zmWq3m.
genie?skin=VG_Base:20 Uncaught TypeError: Cannot set property 'innerHTML' of null
at displayTime (genie?skin=VG_Base:20)
genie.js?mtime=20171006161526:575 Refused to set unsafe header "Content-Length"
send.send @ genie.js?mtime=20171006161526:575
This worked before our upgrade. Other database access is still correct. Thanks.
SELECT DISTINCT (CASE SUBSTR(INTVAL,1,1) WHEN ' ' THEN ''' ''' ELSE INTVAL END) || ':' || CNDTXT, INTVAL FROM CSVLLSP WHERE @@CND=1104244 and CNDTYP='VAL'
Okay, that looks like a legitimate SQL statement. (Despite that you said earlier that there wasn't an SQL statement there.) Look at the response from the PUI00091xx program in your browser's developer tools. What does it say?
Firebug?! That's an old, obsolete, plugin for Firefox. Chrome has it's own built-in tools.
In Chrome, press Ctrl-Shift-I (or, if you prefer to use the menu, click "More tools" then "Developer Tools"). Then click "Network" at the top. Then, navigate to the screen with the drop down that isn't working.
For a database-driven dropdown, there should be a call to PUI0009103, so you'll see that come up in the network tab when it tries to load the drop down. (It will only show up if the screen is loaded after you've already opened the network tab, so you may have to exit and re-visit the screen if you opened the tab too late.) Click on the PUI0009103 line in the network tab, and then select "Response".