I know I can set messages off. I want to trap the error so I can do some error handling.
Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected] "Life doesn't have a remote, get up and change yourself." Please note: e-mail may be subject to public disclosure. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, December 18, 2015 8:58 AM To: Hodges, Dennis Subject: [RBASE-L] - RE: Error trapping on Print command SET ERROR MESSAGE OFF If you do not want the message to show use the above code. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Hodges, Dennis Sent: Friday, December 18, 2015 7:52 AM To: Jim Belisle Subject: [RBASE-L] - Error trapping on Print command 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.
