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

>Hello All,
>
>Codemine 7
>
>I'm having difficulting getting results with the cWhere property of a cursor object. I'm trying to see how I can change the where clause and requery a cursor. I originally tried something like:
>
>

>oCursor = thisform.oCDE.getcursor(thisform.cWorkArea)
>oCursor.cWhere = "statusCode = ?lcStatusCode"
>oCursor.requery("01")             && hard coded test case

>
>But I was not getting a result (recCount() was zero). Then I tried to get all records from the table, by putting the following code into a command button on a form:
>
>

activate screen
>
>oCursor = thisform.oCDE.getcursor(thisform.cWorkArea)
>oCursor.cWhere = "1 = 1"               && just a test to get all records...
>? "requery: ",oCursor.requery()        && returning true
>? "record count:",oCursor.reccount()   && shows no records
>? "cSource:",oCursor.cSource           && the where clause is the same as the original view
>

>
>Are there any Codemine users out there?
>
>Thanks,