At 03:17 PM 7/17/2009, John Engwer wrote:
However, does anyone know why the error variable is not setting. It does set if the select fails. But if the print command fails it does not.
John, Technically, PRINT and LBLPRINT commands to print report and labels, does not set the error variable to a non-zero value when no rows satisfy the where clause. Use the SELECT from the table/view the report/label is based on using the same WHERE clause to be used for printing the report or labels to check the error variable before printing. Take a look at 2009 SAT sample applications to implement such techniques to achieve your goal. 2009 SAT Sample Applications: http://www.rupdates.com/Sat2009 Very Best R:egards, Razzak.
