Hello Mr Wynne, Sir ;)

I am using a SQLPT cursor, based on an RV. The RV had a where clause, and the cWhere property is anded (is that a word?) with the where clause extracted from the RV.

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.

Dave gave me quick and good email support on this issue yesterday evening.

Thanks for responding...

>Mr Gibson, Sir:
>
>Irrespective of whether what you are doing is right or wrong, you should bear in mind that the cWhere property of the cursor class is only to be used for SQL Passthrough, ADO and Dynamic Remote Views only. You haven't specified the type of cursor you are using but it seems that you may not be using an appropriate cursor type. This will not work on a local view.
>
>HTH
>