In short I have a forum which sucessfully gets the first record from the DataConnection. The problem is I seem to only be able to get the first record and cannot navigate to other records.
Any suggestions on what I am missing?
-I am using a MS Access database (.mdb format) with the Microsoft Access Database driver.
-I tried using both User and System DSN's in windows which I am calling when setting up the Data Connection.
-When configuring my DSN's the tests always succeed (and I can call the first record).
-Setting up the Data Connection in Adobe seems to work and shows all of the possible fields in my table.
-I bind my fields to the form, preview it, and see the first record in my table.
-I can add many types of buttons that work, such as printing, emailing, or changing pages of the form, but anything related to database record navigation is not working.
-I am positive that when I call xfa.sourceSet.DataConnection.next() that the 'DataConnection' name is matching exactly my actual Data connection.(seems to be a common problem for people)
-I've followed about 3 different tutorials exactly and they seem easy to go through, but when they add their Next button it works fine. Mine doesn't.
-I've tried starting from a new, blank project as well but cannot change records.
-I've even tried adding or removing the semicolon at the end of: xfa.sourceSet.DataConnection.next();
What am I missing? Is there something potentially wrong with my data connection even though it seems to work?
Now that I have even changed databases and ODBC drivers, what am I still doing wrong? Once I set up the DataConnection in LiveCycle I am then right clicking on it to select 'Generate fields' or clicking and dragging the fields from my DataConnection to the form. It displays the data, but why can't I work with it.
What am I doing wrong?
I am desperate.
The debugging doesn't do anything when I hit a basic 'print' or email' button on my form from within Acrobat, but if I click any of the Next/Previous/First/Last buttons etc it will fire up the debugger and point to my xfa.sourceSet.DataSource.[command] line as if it were problematic, but I don't know how to get any useful info from the debugger in regards to what the problem actually is.
Europe, Middle East and Africa