oCursor = thisform.oCDE.getcursor(thisform.cWorkArea) oCursor.cWhere = "statusCode = ?lcStatusCode" oCursor.requery("01") && hard coded test caseBut 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 viewAre there any Codemine users out there?