In 2004, 4th Dimension has added a set of ODBC native commands. When using these commands, users can encounter an error either from 4th Dimension or from their data source. With the command ODBC GET LAST ERROR, the user can now know the exact error. The example below demonstrates how the command is used.

  C_LONGINT($errCode)
  C_TEXT($errText;$errODBC;$errSQL)

  ODBC GET LAST ERROR($errCode;$errText;$errODBC;$errSQL)

The $errCode parameter will return an error code. The $errText parameter will return an error text. The $errODBC parameter will return the ODBC error code. The $errSQL parameter will return the native data source error code.