hello, i have a DB that usually has current records, but every so often, there are no active records, it gets stuck in a loop, and i have to user abort it... how do i exit the loop when there are no more records to omit... thanks in advance.

Enter Browse Mode

Go to Layout ("invoice summary" (invoice table))

Show All Records

Go to Record /Request/ Page [First]

Loop

If [invoice table::invoice status = "current")

Set Field [invoice table::days; If ( invoice table::invoice paid yn = "awaiting"; (Get ( CurrentDate) - invoice table::invoice date;"")]

Set Field [invoice table::pay beth: If ( invoice table::ER Income paid yn "holding"; "!";"")]

Set Field [invoice table::pay mike; If ( invoice table::Mj Income paid yn "holding"; "!";"")]

Go to Record/ Request/ Page [Next; Exit after last]

Else

Omit Record [color:red](this is where it is getting stuck - when there are no more records to omit)

Allow User Abort (On) [color:red](then i have to abort it here)

End If

End Loop

Sort Records [Restore; No dialog]

Move/Resize Window (Current Window; Height: 950; Width: 1600; Top: 0: Left: 90)

Adjust Window [Resize to Fit]

Try:

...

Loop

Exit Loop If [ not Get(FoundCount) ]

...

that works perfectly, couldn't find the "Get(FoundCount)" command in the script calculation, so copy/pasted "not Get(FoundCount)" in place. thanks very much.