Hi Bob, Since nobody else has taken a crack at it I will. I do not think that ON ERROR does what you want. The syntax you have is wrong for that command.
There are several ways to check for errors. The most useful is to set the ERROR VARIABLE and check it. It will give a number that correlates to the type of error encountered. I believe the ERROR VARIABLE might be what you are looking for. Another way is to use SQLCODE which give you the result of any SQL command. The WHENEVER command can be used to run specific code upon SQL errors occurring. There are some newer commands called ON ERROR, ON CONNECT, and ON PACK. These are all documented at http://www.rsyntax.com I am not sure what you know already and what you are really asking for. If you need help with a specific command then let us know. Best regards, Mike Young On Thu, 27 Sep 2001 13:38:28 -0400, Bob Powell wrote: > >Hello Everyone: > > I think I remember see either on this list serve or >in my reading a way to check for an actual error code >condition. > >I think it went something like : >IF ON ERROR(947) etc. > >Does anyone know about this? >---------------------- >Bob Powell >The Hotchkiss School >Lakeville, Connecticut >Systems Administrator >[EMAIL PROTECTED] > > >
