Crash Magic Online
  Intersection Magic
  Map Magic
  Knowledge Base
  Contact Us


Knowledge Base Article:CMO204 

Registration keys moved to client area: Select login on the left menu bar.

Search home page  

Expression Parser Returns Errors as "Null"

Article created: Jan 12 2009, updated: Apr 21 2010

Background:  Functions that are parameters of other functions are returning null instead of errors.

Status:  Bug - with workaround and upgrade
Keywords:  Expressions,Config,Expression Parser,Calculated Fields
Categories:   *Configuration* *Errors / crashes*


The function: Max(AsNumber(VALUE)) should return an error in the event that VALUE is not a number. Instead this function will return a null value. This bug can cause expressions that should have returned an error to return null instead.

Another expression that this bug can be seen is in the BuildDate function. BuildDate is often used to create a date from 2 or more fields in a database. In the event that an invalid date is stuck into BuildDate it will return a null if it is used as a parameter of another function (like DateDiff).

The most common expression that this error will occur in, are type casts (AsNumber, AsString, AsDate). These functions can take a variety of data types, and will not be able to rely on the type checking that databases have built in.


This issue has been resolved in version 2.13 or newer. It is recommended that you upgrade to the current version of Crash Magic Online.

October 22, 2019 11:37PM

© 1999-2019 Pd' Programming, Inc - Lafayette, CO USA