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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Accessing SQL Table Views with LiveCycle Data Connection

Avatar

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

Avatar

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