Design a Form to display multiple database columns using SQL Request controls

Topic

When adding an SQL Request Control to a form only one field (column) will be returned. A potential work around is to add multiple SQL Request controls.

Instructions

1) Create the first SQL Request control and configure the "display format" as "text" to query the primary key column of the desired database record.
2) Create a Form variable of type string and name it after the primary column and populate it with the value returned by the first SQL control.
3) All proceeding SQL Request controls need to contain a select statement with the desired field and also include a where clause to include the primaryKeyField = <primaryKeyVariable>

 

Version history
Revision #:
3 of 3
Last update:
‎10-27-2020 05:23 PM
Updated by:
 
Contributors