From what I can see there is nothing wrong with this statement. There must be something other than this piece of code causing the endless loop.

Maybe you've got some corrupted index set on table1, Just try the following:

SELECT Table1
SCAN FOR OWE <> 0
ENDSCAN

does it end in an endless loop now ?
If it does, your index or table might be corrupted,

If it doesn't, something in TABLE2 (maybe a SET RELATION) might cause the record pointer in TABLE1 to reset again. Maybe you can ADD a SET STEP ON before the SCAN, Open the two tables in a browse window and step through the code. You might find the cause this way.

Walter,



>Nope... didn't work.
>Thx