Excel navigation

[Former Community Member]

I've created a PDF in Designer 8.0 and have added a data connection to an OLEDB source to my Excel file on my hard drive. It works fine in displaying the data, but when I add a button to move to the next record, it doesn't move to the next record. The command i'm using is:



xfa.sourceset.dataconnection.next()



Would anyone know why or at least used this next() command for any other data connection?



thanks

[gkaiseril]

You have to use Acrobat JavaScript's "Statement" object to execute the SQL quires.



Have you looked at LiveCycle's Developer Center's examples:



http://www.adobe.com/devnet/livecycle/designer_scripting_samples.html



Scroll down to the "working with data sources"

[Former Community Member]

I have an odbc data connection to an AccessXP database. My Master form has a data drop down list object that populates the names from my AccessXP table. I am sorting the file alphabetical by name.



I have textfields representing the name, address1, address2, address3



I can see the first sorted record of the table populating the name and address fields. I have buttons to navigate through the database. Using the same syntax you wrote works for my "forward" button. So you should be good to go.



What has me stumped is how to navigate to the selected record from my drop down. I can select a name from the drop down but the change script isn't working for me.



Here is a link to some resources that have helped me get to this point.

http://forms.stefcameron.com/category/data-binding/



I hope this helps.

Pam

[gkaiseril]

There is also a LiveCycle Designer tip for doing a DB lookup to populate a drop down list which is then used to lookup a selected record and populate 4 fields.



http://partners.adobe.com/public/developer/en/livecycle/lc_designer_db_lookup_tip.pdf