RandallKWright
asked on
Adobe Designer/Adobe Reader Compatibility Question (with Data Connection)
I have used Adobe Designer 7.0 to build a simple form to be used by our employees for Accounting classification. Within this form I have several drop down list boxes, some text boxes and a button. I have two data connections, connected using the OLEDB wizard, to an access database I have on a shared network drive. I pulled some code from the net that uses both Javascript and FormCalc to manipulate the data on the screen. On my desktop, where I have the full Adobe suite, the form functions as expected. The drop down boxes populate and the button will refresh the text boxes based on the list box selection. On another user's machine, I set up the ODBC data source, and tried opening the PDF document. The form opens fine (the Reader is 7.0) and populates the drop down boxes with data from my Access tables. However, when I click on the refresh button (which uses the FormCalc script), I get a scripting error:
Error: accessor '$sourceSet.DataConnection 2.#command .query.Com mandType' is unknown.
The full formcalc code block is as follows:
----- form1.#subform[0].Button1: :click - (FormCalc, client) -------------------------- ---------- ----
if (Len(Ltrim(Rtrim(SelectFie ld.rawValu e))) > 0) then
$sourceSet.DataConnection2 .#command. query.comm andType = "text"
$sourceSet.DataConnection2 .#command. query.sele ct.nodes.i tem(0).val ue = Concat("Select * from none_AP_VENDOR Where NAME_KEY = ", "'", Ltrim(Rtrim(SelectField.ra wValue)) ,"'")
$sourceSet.DataConnection2 .open()
$sourceSet.DataConnection3 .#command. query.comm andType = "text"
$sourceSet.DataConnection3 .#command. query.sele ct.nodes.i tem(0).val ue = Concat("Select * from none_GL_TRIAL_ACCT Where NAME_OF_ACCOUNT = ", "'", Ltrim(Rtrim(AccountDesc.ra wValue)) ,"'")
$sourceSet.DataConnection3 .open()
endif
Is this type of code supported by the Reader? Any help or guidance would be appreciated.
Randy
Error: accessor '$sourceSet.DataConnection
The full formcalc code block is as follows:
----- form1.#subform[0].Button1:
if (Len(Ltrim(Rtrim(SelectFie
$sourceSet.DataConnection2
$sourceSet.DataConnection2
$sourceSet.DataConnection2
$sourceSet.DataConnection3
$sourceSet.DataConnection3
$sourceSet.DataConnection3
endif
Is this type of code supported by the Reader? Any help or guidance would be appreciated.
Randy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Randy