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]
