>Sir, Mr Gibson, Sir
>
>>is anded (is that a word?)
>
>Seemingly 'tis in Texas <s>.
ANDed is the word Dave used, and he's not in Texas <g>
>
>>I removed the where clause from the underlying RV, so the where clause is exclusively controlled by the cWhere property of the cursor. It is working perfectly now.
>
>Makes eminent sense.
I suppose it could have been implemented to replace the original where clause, and that might have made sense, too...but I think the way it is will do the job.
>
>By the way, what back-end are you using? How are you finding the SQL capabilities of Codemine?
>
I'm using SQL Server 7 (the MSDE version). I'm finding the SQL capabilities by trial and error *grin*. But seriously, so far it seems good to me, but I'm pretty new in the SQL Server realm. Which means my opinion doesn't count for much.
Steve Gibson