Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

Non-Numeric Data (OpenInsight Specific)

At 07 FEB 1999 05:35:11PM William Crosley wrote:

We have converted programs from ARev to OI.

Under ARev when non-numeric data is encountered in a calculation:

     a=b + c        (c is non-numeric)

zero is used and the program continues. In OI the debugger appears.

The ARev approach is more user friendly. Is there a flag in OI which allows non-numeric data to be converted to zero without the debugger appearing?


At 07 FEB 1999 06:52PM J. Shaefer wrote:

I don't know what version of AREV you have been using but I just wrote a quick program to test your theory:

a='

b=1

c=r' ;* non numeric

a=b + c

Print a

The program broke with an error stating that non-numeric data when numberic required was used????

Maybe you can just use an if statement to check for the data prior to calculation or even a case statement and set the variable to zero if it's non-numeric


At 08 FEB 1999 03:31PM Colin Rule wrote:

Start Database Manager.

Select the menu Database, Environment Settings.

There is a check box to enable/disable debugger.

Suggest it is enabled until deployment.

It does give a beep though if an error occurs, but much better for the end user.

View this thread on the forum...