ODBC data sucessfully connects, but NEXT button doesn't work

in short have forum sucessfully gets first record dataconnection.  problem seem able first record , cannot navigate other records.

 

i have added next button, set javascript, client, on click common xfa.sourceset.dataconnection.next();      code, when previewing form (still within livecycle) though can sucessfully pull first record table, clicking 'next' button nothing @ all, not error.

 

any suggestions on missing?

 

other info:

-i using ms access database (.mdb format) microsoft access database driver.

-i tried using both user , system dsn's in windows calling when setting data connection.

-when configuring dsn's tests succeed (and can call first record).

-setting data connection in adobe seems work , shows of possible fields in table.

-i bind fields form, preview it, , see first record in table.

-i can add many types of buttons work, such printing, emailing, or changing pages of form, related database record navigation not working.

-i positive when call xfa.sourceset.dataconnection.next()  'dataconnection' name matching actual data connection.(seems common problem people)

-i've followed 3 different tutorials , seem easy go through, when add next button works fine.  mine doesn't.

-i've tried starting new, blank project cannot change records.

-i've tried adding or removing semicolon @ end of: xfa.sourceset.dataconnection.next();

 

what missing?   there potentially wrong data connection though seems work?

 

thanks.

-mike

today did troubleshooting.  instead of using ms access set simple mysql database 3 text fields (no auto-incrementing fields).  again able connect livecycle form mysql odbc data source , display first record table buttons click actions run , javascript lines beginning xfa.sourceset.{name of data source in lc here}.* commands not work @ all.

 

i know buttons work.  can run xfa.host.messagebox("blah") commands test clicking buttons triggers javascript code, it's xfa.sourceset.* lines aren't working.

 

now have changed databases , odbc drivers, still doing wrong?  once set dataconnection in livecycle right clicking on select 'generate fields' or clicking , dragging fields dataconnection form.  displays data, why can't work it.

 

what doing wrong?

i desperate.

More discussions in LiveCycle Designer

adobe