Error: accessor 'xfa.sourceSet.DataConnection.next()' is unknown.

[lnadai]

Only started using LCD ES a couple of days ago.

I was able to connect a form via ODBC/MySQL.

It correctly displays the first row.

I was trying the following scipt on a "next" button:

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

xfa.sourceSet.DataConnection.next()

When running, I get the error:

Script failed (language is formcalc; context is
xfa[0].form[0].form1[0].#subform[0].dbNext[0])
script = fxa.seourceSet.DataConnection.next()

Error: accessor 'xfa.sourceSet.DataConnection.next()' is unknown.

Hope this is an easy one to answer.

Also any links to basic example for a simple OLEDB based for design would be appreciated.

(I got this one from a blog, but I coudn't make it work).

Thanks in advance.

[MaxCompana]

Hi. I'm facing the same problem. Did you find anything to solve it yet?

If yes please help me.

Thanks

[lnadai]

nope, I gave up.

I am using PDFill. Cheap, and works

-laszlo

[_Nith_]

You must replace the word DataConnection with your actual data connection name. Did you try that?

Nith

[MaxCompana]

Hi Nith, thanks for the reply. Dataconnection is the actual name. I just

left the default name. What is very strange the syntax check doesnt give any

errors or warnings- the error is shown in the runtime.

Nith, do you have a working example? I'm fighting this problem for several

days without much of success.

Sincerely

MaxCompana

[lnadai]

of course

[Former Community Member]

I have this exact same problem and have found no reason why this is happening after 3 days of scouring the internet.   In regards to the OP problem.  If I run the button code in FormCalc mode I get the same error as in the OP question and if I switch it to JavaScript the error goes away, but the code in the button does not respond.

Any ideas on why  xfa.sourceSet.DataConnection.next()

or

xfa.sourceSet.{the name of my data connection}.next()

does not work?