>Using the Query Builder in the Data Adapter Config Wizard I build the statement: SELECT HINIT,HNAME FROM HWHOA WHERE (HINIT = ?). Keep getting error: No value given for one or required parameters. Hardcoding the search value (HINIT = "BWP") works fine...
>
>-Todd

SELECT HINIT,HNAME FROM HWHOA WHERE (HINIT = @hinit)

where hinit is the parameter name. The config wizard should create the required parameter initialization code for you. All you need to do is load the parameter value(s) before executing the select.