Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualDeveloping with the Firebird ODBC/JDBC Driver → Usage with Clarion
Firebird Home Firebird Home Prev: ARRAY Data TypeFirebird Documentation IndexUp: Developing with the Firebird ODBC/JDBC DriverNext: Firebird Events

Usage with Clarion

Jorge Andres 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.

Prev: ARRAY Data TypeFirebird Documentation IndexUp: Developing with the Firebird ODBC/JDBC DriverNext: Firebird Events
Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualDeveloping with the Firebird ODBC/JDBC Driver → Usage with Clarion