jr87794863

Hi,I have a Livecycle designer 8 form and used dynamic dropdownlist with ODBC connection. After applying usage rights to the form using acrobat professional when i open with reader my first dropdown is showing records but the dependent dropdown in blank. If i open the same form with acrobat it is working (The second dropdown is populating records according to first dropdown).Anyone have any solution for this.....Please suggest

317

Unable to populate dynamic dropdown list in a dynamic form - Adobe LiveCycle

Hi,I have a Livecycle designer 8 form and used dynamic dropdownlist with ODBC connection. Also creating Instances of a table on button click.Now when i set "Preview Adobe XML form as" Dynamic and save as "dynamic xml form" the dropdown showing no result but instance is working and when i set "Preview Adobe XML form as" Static and save as "static xml form" the dropdown showing the results but instance is not working.How to setup the form so that both the functionality work properly. My form : Dro...

374

How to setup "Preview Adobe XML form as" in a form? - Adobe LiveCycle

I have a Livecycle designer 8 form.I have used dynamic dropdownlist with ODBC connection. Also creating Instances of a table on button click.Now when i set "Preview Adobe XML form as" Dynamic and save as dynamic the dropdown showing no result but instance is working and when i set "Preview Adobe XML form as" Static the dropdown showing the results but instance is not working.How to setup the form so that both the functionality work properly.

317

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,I think we should leave the dropdown issue here,it's not gonna resolve.If possible please check the "Add More" instance.It adds a new instance but not able to see it.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

It's not working.It shows the first record only in both state and city.If i take Data dropdownlist in state then it shows all the states but with standard dropdown it is only the first record.But city value fixed with first record only if i use preOpen code.I tried your sample form also just replacing the dataconnection but same result.I have changed Form preview type to interactive. What is the difference between them.Please update the form i uploaded yesterday.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Now i have installed Trial version of Livecycle designer ES4.And edited my previous form with it. Dropbox - testChk - new.pdf .Please make some necessary changes in my form.Hoping the code in designer ES4 will work on designer 8.0 also.If possible please also check the "Add More" Instance also.Very badly need now.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Please try to update my form or if possible please create a sample form which is accessible in designer 8 with my database script.I tried everything but no result.Thanks in advance.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

changed the setting of bofAction and eofAction values in connection properties and use your code in preOpen but city filed is blank.no records.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

As i'm using Data Dropdownlist for both state and city it is already mentioned in initialize event.var sBOFBackup = oDB.nodes.item(nDBIndex).query.recordSet.getAttribute("bofAction");var sEOFBackup = oDB.nodes.item(nDBIndex).query.recordSet.getAttribute("eofAction");oDB.nodes.item(nDBIndex).query.recordSet.setAttribute("stayBOF", "bofAction");oDB.nodes.item(nDBIndex).query.recordSet.setAttribute("stayEOF", "eofAction");Do i need to use this in preOPEN also.

3.3K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Thank you for your reply. I'll try the code and let you know. This designer version is provided by my office. can i upgrade it for free.

3.4K

Dropdownlist binds value field when export to xml - Adobe LiveCycle

Hi,I have created a user form with livecycle designer 8.The form is having some dropdownlist and gets data from database using ODBC connection.When i export the filledup form to xml it binds the selected value with the field.

252

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Anyone have solution of this please suggest me.I have already attached my form and database script above.

3.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

I have changed it.Please find my database script here.Dropbox - script.sql

3.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Please try to update my form.Attaching my sql server database script.Dropbox - script.sql .Please need very urgently.Thanks in advance.

3.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

It gives Error: accessor 'xfa.sourceSet.city' is unknown. I think Stefan is displaying the dependent data in a Text field but i want to display the list of data in drop down.

3.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

I am also using FormCalc in change event but javascript in initialize.And i have now used data dropdown list in both as mention in this article.

3.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,I have used the second link you provided by you http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/ but it gives error message Error: accessor 'xfa.sourceSet.city.#command.query.commandType' is unknown.my code in 1st dropdown change-----------------------------------------------var sCategoryName = xfa.event.newTextvar sCategoryId = $.boundItem(sCategoryName)xfa.sourceSet.city.#command.query.commandType = "text"xfa.sourceSet.city.#command.query.select = concat("SELECT ...

7.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,How can i do this.could you please do some necessary changes in the form and send back.What i have written in the presSTATE Change is not working.and other than this please check the instance issue also.It will be a great help.Please.

7.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,No presCity is not static.It get the data from database. If i'll not bind the presCITY with dataconnection it goes blank.City is coming from same database but different Table.How can i do this dynamically. And please also check the Add instance of Education Table.It is added but not showing up. Please give some solution to both problems.Very urgently needed.Thanks in advance.

7.4K

Re: how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

Hi,Please check the file and suggest some solution.Very urgently needed.Plzzz

7.4K

how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

I'm creating a user form using Livecycle designer.Here i'm not able to implement cascaded dropdownlist using javascript. I'm using ODBC dataconnection for data binding.Able to bind all data in respective dropdowns but don't know how to use cascading.I followed this link LiveCycle ES2 * Adobe LiveCycle Designer ES2 but is is not working.

291

how to create dynamic dependent dropdownlist using ODBC in LiveCycle? - Adobe LiveCycle

8.9K

How to get data from LiveCycle form when user uploads the pdf form - Adobe LiveCycle

I have a user form which i have created with LiveCycle Designer 8.User need to download the form and fill the fields and upload the PDF. Now after upload i want to get the data from that form and store in database.

308

Guidelines

Cookie preferences