dynamically bind a dropdownlist with button Livecycle 8.2
Can someone please tell me why this code does not work? Nothing happens when I click the button. The dropdownlist populates fine when the form loads, but I cannot get it to repopulate. I have tried hardcoding the parameter with aLike, =, etc.
Not sure what you are trying to do with the bindItems call. Are you trying to change the binding of the dropdownlist on the fly?
Yes, I found the following example. I am trying to connect it to an access db. I tried the following code and I can see that at least one record is found with the select statement. However, the while statement does not populate the dropdownlist with any data. the last line is able to add one list item manually. Can you tell me what is wrong with this code? The oca table does have myname and id as fields. This formcalc script runs with a button click event.
var sCategoryId = sname.rawValue
var oDataConn = Ref(xfa.sourceSet.DataConnection.clone(1))
oDataConn.#command.query.commandType = "text"
oDataConn.nodes.item(1).query.select.nodes.item(0).value = concat("SELECT * FROM oca WHERE last Alike '", sCategoryId, "'" )