Call UD adapter with where clause

[knash (Ken Nash)]

or here.

Is it my code or the Adapter failing here?

Here is the final modified code for anyone interested. I’ll mark it as solution but it was @josecgomez @danbedwards that get the credit public JobPartDataSet GetJob(string jobNum) { bool more; JobPartAdapter jpAdapter = new JobPartAdapter(oTrans); jpAdapter.BOConnect(); SearchOptions opts = new SearchOptions(SearchMode.AutoSearch); opts.DataSetMode = DataSetMode.RowsDataSet; opts.PageSize = 20; //return th…