KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Getting information regarding an error when using OBDC commands
PRODUCT: 4D Server | VERSION: 2004 | PLATFORM: Mac & Win
Published On: February 8, 2005
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.