FirebirdSQL logo
 Connecting to Firebird from ApplicationsFirebird Events 

Usage with Clarion

Jorge Brugger; Vernon Godwin; Vladimir Tsvigun

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).

That’s it!Now use your dictionary with mixed case identifiers, without problems.But remember — you must use double quotes around object names in all SQL statements from inside Clarion.