List Box - Import process

When importing Option Text and Option Values into a List Box control using the Microsot SQL server datasource, the import process will fail if the SQL query used contains a WHERE clause. The import wizard adds extra quotes around the test value, this causes no data to be imported into the control.

 

For example the following SQL query will import values because all values from the table are being imported into the control.

 

SELECT Name, script_id FROM tbl_Scripts