Does anyone have any suggestions on how to end this routine gracefully and continue onward?
Does one check: Error Codes? SQL Codes? Preset value in .vConsignor to 0 or something and test if not 0? Please point me in the right direction. LABEL NextCheck --CLEAR variables --and calculate Other stuff here then --TEST if there are any checks to be printed SELECT CustNumber INTO vConsignor + FROM ConsignView + WHERE DateSOLD BETWEEN .vBeginDate AND .vEndDate + AND CheckNumber IS NULL + AND Limit = 1 --Eventually a point is reached where there are NO rows that qualify --and my program just ends ungracefully with uncleared variables --However when we have valid data we actually print the next check OUTPUT PRINTER --PRINT report OUTPUT SCREEN --and UPDATE stuff here GOTO NextCheck Ned
