Accessing SQL Table Views with LiveCycle Data Connection

Avatar

Avatar

expeegee

Avatar

expeegee

expeegee

30-09-2015

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

koreyspremier

Avatar

koreyspremier

koreyspremier

15-03-2016

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