Using the Firebird ODBC driver with Clarion

Clarion users can work with mixed case object names in Firebird.

  1. Create your database in Firebird. You can use table names like "Pending_Invoices" and fields like "Order_Number".
  2. Create the DSN for the Database, making sure to check all options in "Extended Identifier Properties"
  3. Open your dictionary, and import multiple tables as normal from the odbc source. It will work, but do not try to browse or use the files in an application yet.
  4. For every field, type in the 'External Name' the name of the field surrounded by quotes (for example, type "Order_Number" in the external name).
  5. That's it! Now use your dictionary with Mixed_Case_Identificators without problems. But remember - you must use double quotes around object names in all sql statements from inside Clarion.

Thanks to Jorge Andres Brugger, Vernon Godwin and Vladimir Tsvigun for the info contained in this document.