I have created a dropdown list when item selected to change sub form to visable and populate fields with data from a sql database. I get data for the dropdown list but when selecting an item from the list I get this error:
Script failed (language is formcalc; context is xfa.[0].form[0].#pageSet[0].state[0].DataDropDownList[0])
script=
var sPropertyName = xfa.event.newText
var sPropertyId = $.boundItem(sPropertyName)
xfa.sourceSet.DataConnection2.#command.query.select =
concat("SELECT PrintName, Title, SignDate FROM tblState WHERE PropertyID = ",
sPropertyId, " ORDER BY Title;")
xfa.sourceSet.DataConnection2.#command.query.commandType = "text"
xfa.sourceSet.DataConnection2.open()
xfa.sourceSet.DataConnection2.first()
StateSub.presence = "visible"
Error: Property: 'select' cannot be set because doing so would violate the document's permissions settings.
Help would be very much appriciated! Thanks,
Pat