In the following print command if the where command returns no records, the value of holder is 0, but I get a 2059 error message. How can I trap this error?
SET ERROR VARIABLE verrvar PRINT needfile ORDER BY site WHERE datecomp IS NULL AND ((crew1 = .zcrew) + OR (crew2 = .zcrew) + OR (crew3 = .zcrew) + OR (crew4 = .zcrew)) + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE percentage 98 set var holderr = .verrvar thank you, Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected]<mailto:[email protected]> "Life doesn't have a remote, get up and change yourself." Please note: e-mail may be subject to public disclosure.
