Tech Tip: The new GET LAST ERROR STACK command

PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win

Published On: March 11, 2009

4D v11 SQL Release 3 has a new command: GET LAST ERROR STACK. It replaces the GET LAST SQL ERROR command from 4D v11 SQL Release 2. If you open a database from 11.2 in 11.3, the command will be changed in all methods. If you then open the same database in 11.2, the command will revert to GET LAST SQL ERROR.

Although the name has changed, the syntax is still the same:

GET LAST ERROR STACK (codesArray; intCompArray; textArray)

Where:

Parameter       Type		Description

codesArray	Number array	Error numbers

intCompArray	String array	Internal component codes

textArray	String	array		Text of errors

Commented by Atanas Atanassov on April 9, 2009 at 10:22 AM

This command actually enhance the functuionality of "On Err Call" . Because you can have only one error handling method installed with "On Err Call" per process, with this command the error method can handle multiple errors for the process.