Hi all

Comments/hints/suggestions please! Thx!

From discuss.softvelocity.com comp.lang.clarion

Well ... First of all, I want to give thanks to all who helped me,
specially Vernon Godwin (Clarion Developer) and Vladimir Tsvigun (actual
developer of the open source ODBC driver for Firebird). Most parts of
this how-to are its ideas, not mine.
I´m asking to everyone to test the how-to, and to correct the bad
english and those things that "maybe" doesn't work :)
Let´s go ...

HOW TO USE FIREBIRD WITH MIXED CASE OBJECT NAMES AND CLARION (including
the import from the DB to the Clarion dictionary)

1. Create your database in Firebird. You can use table names like
"Pending_Invoices" and fields like "Order_Number".
2. Follow the step 2 from the Chris Buechler's "step by step"
(http://www.eicsoftware.com/firebird/)
3. Download the "tweaked" version of the ODBC driver from
http://www.dasu.com.ar/clarion/OdbcJdbcBeta2_Clarion.zip (it contains a
change sugested by Vladimir and made by me to make Clarion import files
work). Replace the windows/system32 dll´s with the tweaked ones.
4. Create the DSN for the Database
5. Open your dictionary, and normally import multiple tables from the
odbc source. It will work, but do not try to browse or use the files in
a app yet.
5.a If you don´t trust me or have doubts about my compilation of the
driver, or need to use the database from other software via odbc, you
can now install the "official" ODBC driver again (make sure that Clarion
is closed before trying this)
6. For every table, open his properties and add quotes to the 'Full
Pathname' option (In the example change Pending_Invoices to
"Pending_Invoices". Also add /VERIFYVIASELECT=TRUE in the driver options
7. For every field, type in the 'External Name' the name of the field
surrounded by quotes (in my example, type "Order_Number" in the external
name).
8. It´s done! Now use your dictionary with Mixed_Case_Identificators
without problem.

Maybe if I export the dct after step 5, the steps 6 and 7 could be done
more "automatically" using the TXD and a text editor. After that, all
you have to do is import the modified TXD in a blank dictionary.

If this is useful for the Clarion Community, good, and if not, at least
it was for me ;)

I know also that I´m not so good writing in english, but surely I´ve
made my best effort.

--
Jorge Andrés Brugger
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar

=====================
Johan van Zyl
JVZ Systems CC
Box 3469
Somerset West
7129
082 875 4238
021 8517205
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.656 / Virus Database: 421 - Release Date: 2004/04/09