Link to home
Start Free TrialLog in
Avatar of RandallKWright
RandallKWrightFlag for United States of America

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.DataConnection2.#command.query.CommandType' is unknown.

The full formcalc code block is as follows:

----- form1.#subform[0].Button1::click - (FormCalc, client) ----------------------------------------

if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then
      $sourceSet.DataConnection2.#command.query.commandType = "text"
      $sourceSet.DataConnection2.#command.query.select.nodes.item(0).value = Concat("Select * from none_AP_VENDOR Where NAME_KEY = ", "'", Ltrim(Rtrim(SelectField.rawValue)) ,"'")
      $sourceSet.DataConnection2.open()

      $sourceSet.DataConnection3.#command.query.commandType = "text"
                $sourceSet.DataConnection3.#command.query.select.nodes.item(0).value = Concat("Select * from none_GL_TRIAL_ACCT Where NAME_OF_ACCOUNT = ", "'", Ltrim(Rtrim(AccountDesc.rawValue)) ,"'")

                $sourceSet.DataConnection3.open()
endif

Is this type of code supported by the Reader? Any help or guidance would be appreciated.

Randy


ASKER CERTIFIED SOLUTION
Avatar of Lucrecious
Lucrecious
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RandallKWright

ASKER

Thanks for the response. I had pretty much come to the conclusion that there was just enough functionality NOT available thru the reader to make my life difficult!!! We're a pretty small company right now, so I was able to come up with an alternate solution that works for us. I'll research the links you provided and use them for future reference. Thank you again.

Randy