Tech Tip: String Overflow Errors in 4D v11 SQL
PRODUCT: 4D | VERSION: 11.5 | PLATFORM: Mac & Win
Published On: January 8, 2010
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
In versions prior 4D v11 SQL it was possible to pass an element beyond the string length. For example:
In previous versions of 4D, the value of $myChar would be an empty string, and 4D would continue with the code execution. In version 11 this code will throw a Syntax Error 53; indice out of range. This error can be handled by checking the string length first or trapping the error with the ON ERR CALL method.