May be you are in wrong record?
What the following code gives you?
SELECT table1
SCAN
cState = CHRTRAN(GETFLDSTATE(-1, "Table1"),"01","")
lchange = .NOT. EMPTY(cState)
WAIT WINDOW TRANSFORM(RecNo())+" "+GETFLDSTATE(-1, "Table1")
ENDSCAN
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.