Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Accessing SQL Table Views with LiveCycle Data Connection

expeegee
Level 1
Level 1

I am creating a fillable PDF with a data connection to a SQL database. The idea is that when the user enters a unique value in one of the fields and presses a refresh button, the form will pull in certain fields of data from a SQL database. My issue is that, when creating the ODBC data connections in LiveCycle Designer, I only seem to have access to the tables in the database, not to the table views that have been created. In other tools such as Crystal Reports (that use the same DNS), I have access to both the tables and the views.

Does anyone know if it's possible to access the views as well as the tables in LiveCycle?

Thanks!

1 Reply
koreyspremier
Level 1
Level 1

I have done this using a SQL Query instead of choosing a table.  You could try...'SELECT * FROM MY_VIEW WHERE THIS = THAT'

2016-03-15 16_43_16-OLEDB Connection.png