>>Even for the UC of different WhereFilters in SelectCmd needed, I probably would try if a special CA could handle the safe select gymnastics with a few lines of code to keep data layer on one mechanism ;-))
>
>I'm still investigating... the source of my problems may be the weird behavior in cases when there are two adapters on the same base table, and one of them gets requeried (by either .cursorRefresh(), requery() or refresh()) - first time it may work, second time it seems the cursor of the other one gets closed. Or something like that, still haven't gathered all the evidence.

We have at least one app with some tables where up to slightly more than half a dozen ca query into one table and CursorRefresh() depending on user input - mostly as rowsources for dynamically filled dropdown lists depending on other parts of the program. Do not remember that something special needed to be done, but was using fwk classes - possible some magic was done there, but I doubt it. RO access, but I doubt that could be your problem.