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,