Connect DDL with SQL data

Avatar

Avatar

mmgiath

Avatar

mmgiath

mmgiath

13-08-2015

Hi everyone there, can someone help me about

How I can connect a drop down list with SQL data?

Any sample to start going..?

Thank you

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150
Magus069
MVP

13-08-2015

Well the way I work it out, if the data is sensitive and can only be accessed by your organization, I put the database on a share drive where all user from that same organization can access it..

Therefore, you will need to set the data connection by default on each computer to be able to access to that database using the data sources of your windows...

Otherwise you can load the data from the database and save it on the form and treat the data afterwards without having to connect to the database...

Also, Reader doesn't connect to databases by default unless they have an option checked in the settings, so saving the data on the form will evade the issue of not being able to connect to database with reader, unless they all have acrobat pro that is not an issue

Avatar

Avatar

mmgiath

Avatar

mmgiath

mmgiath

13-08-2015

 

Hi Magus069, thank you for your help in this matter.

 

I am new to this and really I do not know how things work!

 

Do I have to make ODBC Microsoft Access set up for every PC in my office or the data will be somewhere saved in the network/server and from there everyone will pull the data??

   

How I can create the data? With what application?

 

Thank you

 

Avatar

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150
Magus069
MVP

13-08-2015

Hi there,

to be able to bound a drop down list to SQL data, you need to turn on the option Show Dynamic Properties within the options settings of LiveCycle Designer

Tools > Options > Data Binding > Show Dynamic Properties

Then you can select a drop down list and bind items from data connections, just click the green text in the red square in the image below :

ddlSQL.png

Once in the Dynamic Properties dialog, you have all the options you need!

ddlSQL.png

Data Connection: Choose the data connection to have the field's list needed

Items : If Data Connection is selected, the field is disabled

Item Text : Specify what value is suppose to be displayed to the user

Item Value : Specify what value is to be used when using the property rawValue

Hope this help!