bind search to array results
How would I go about binding the search feature to array results (instead of the default recordset style)?
The standard approach works fine:
obitlist_cmd.CommandText = "SELECT * FROM xxxx WHERE display = ? ORDER BY yyyy DESC"
setQueryBuilderSource obitlist_cmd, WADbSearch2_whereClause, false
Set obitlist = obitlist_cmd.Execute
But I am loading the database results into an array, but can't figure out the syntax to bind the search to the array results.
Set OBITrstGetRows = OBITcnnGetRows.Execute("SELECT * FROM xxxx WHERE display = 'Y' ORDER BY yyyy DESC")
????? setQueryBuilderSource OBITrstGetRows, WADbSearch2_whereClause, false
OBITarrDBData = OBITrstGetRows.GetRows()