These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Unable to pull all records from a database table

2010-06-23 15:59:26

kaushiksriram100

Registered: Jun 23 2010

Posts: 9

Hi..

I am working on an interactive pdf form. I am trying to pull an entire column from a table and populate it in a drop down list in the pdf form. But whenever I do dataConnection and stuff and preview it- Only the first row of the column (from Database) gets displayed in the drop down. The list doesn't even expand.. I tried it with .mdb and SQL Server. Any suggestions would help a lot..

- Kaushik

- Kaushik...

My Product Information:
LiveCycle Designer, Windows

2010-06-24 07:59:17

gkaiseril

Online

Registered: Feb 23 2006

Posts: 4307

You have to loop through the database. [url=http://forms.stefcameron.com/2006/10/12/displaying-all-records-from-an-odbc-data-connection/]Displaying All Records form an ODBC Data Connection[/url] and [url=http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/]Databases: Inserting, Updating, and Deleting Records[/url] by Stefan Cameron.

George Kaiser

2010-06-28 07:11:05

kaushiksriram100

Registered: Jun 23 2010

Posts: 9

Thanks,

I tried following the article.. But one place I am stuck is when we create subforms.. When I import the existing pdf and view it in live cycle, the subform object is GRAYED out.. I am unable to use it. But when I import some other form the object is available.. Don't know why.. Any comments would be appreciated..

thanks,

-Kaushik

- Kaushik...

2010-06-28 08:50:12

kaushiksriram100

Registered: Jun 23 2010

Posts: 9

Also note that I am trying to pull some 500+ records from a column into the drop list. I tried my best but often whenever I see the preview the live cycle crashes (sometimes says: "Out of Memory"). The pdf hardly gets saved and previewed.. Is this because of the volume of records I am trying to pull?

-Kaushik

- Kaushik...