I have been having trouble with errors in a database so I set up the routine 
from help:
SET ERROR VAR E1
WRITE 'Checking database for errors...'
AUTOCHK database
IF E1 > 40 THEN
WRITE 'AUTOCHK has found errors in the database!'
BEEP
ENDIF
If E1 > 0 and E1 < 50 THEN
WRITE 'AUTOCHK will not run - User Abort or Out of Memory'
BEEP
ENDIF
IF E1 = 0 THEN
WRITE 'AUTOCHK successful - No errors found'
ENDIF
PAUSE 2
RETURN
When I run this I get no errors, E1 returns 0, but if I run 'autochk database' 
from the R> I get errors and E1 is some big number like 1249.  Any suggestions. 
My ultimate goal is the send me an email saying there is a problem, I have got 
that all setup to work, but since my above routine does not show errors it does 
not send

Tom Hart

Reply via email to