Accessing SQL Table Views with LiveCycle Data Connection

Avatar

Avatar
Validate 1
Level 1
expeegee
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
expeegee
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
expeegee
Level 1

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
Level 1
koreyspremier
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
koreyspremier
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
koreyspremier
Level 1

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