Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Shop
  
  Login
  

 

Knowledge Base Article:CMO204 


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

Knowldegebase:
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*

Explanation:

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.



Solution:

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.


July 21, 2018 9:40AM

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