I have created a form in Live Cycle Designer 8.05 that reads data from a OLEDB System DSN connected to our data warehouse application. I test the form in Acrobat preview from within LCD and Acrobat Pro (and Reader) and I can see the first record. All is good so I add some navigation buttons to click through the records and they do not work. I have used FormCalc and Java versions of the CLICK event and when using xfa.sourceSet.DataConnection.next() and setting the Language to FormCalc and Run AT: SERVER I get the following message when testing with the data: Couldn't post data to ".
When I use the same code but set the Run At: to Client I get the following error: Script Failed (Language is formcalc; context is xfa[0].form[0].topmostSubform[0].form1[0],NextPage[0])script=xfa.sourceSet.DataConnection.next() Error: accessor 'xfa.sourceSet.DataConnection.next()' is unknown.
I suspect the problem is with my DataConnection setup or even my System DSN but I am not sure where to start troubleshooting this.
Any help would be greatly appreciated.
Cheers,
Dave