Livecycle

Using a button to populate fields from a database

You can use a database to provide the data for fields in your form, including text and numeric fields.

In this example, the Retrieve Record button and the list box are bound to the database (named DataConnection) shown in the Data View palette at the left. The button also has a FormCalc script attached to it to retrieve information based on the part number selected in the List Box field. The retrieved records appear in the ID, PART_NO, UNITPRICE, and DESCRIPTION fields.

1.	Connect to the database.

2.	In the Data View palette, drag the UNIT_PRICE, DESCRIPTION, PART_NO, and ID elements under DataConnection onto the form design. Each node dragged onto the form design creates a bound field.

3.	In the Object palette, click the Standard tab and drag a button object onto the form design.

4.	Enter a new name for the button. The example uses RETRIEVE RECORD.

5.	Select the button and, in the Script Editor, select click from the Show list, select FormCalc from the Language list, and select Client from the Run At list.

6.	Enter a FormCalc script similar to the following example. The script retrieves the data in the specified records and prints it in the corresponding fields when the user clicks the button.

//Change the commandType from TABLE to TEXT. TEXT

//is the equivalent of SQL Property

$sourceSet.DataConnection.#command.query.commandType = “text”

 

//Set the Select Node. Select in this case will be

//whatever SQL Property you want

$sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat(“Select*from OfficeSupplies Where ID = “, DataListBox1.rawValue,””)

 

//Reopen the Data connection

$sourceSet.DataConnection.open()

7.	Save the form design as a PDF file.

8.	Test the form using the Preview PDF tab to verify that the script works as expected.

See also 

About previewing and testing forms

About data sources

To create a bound field or subform

Overview of buttons

Using a button to populate fields from a database