A basic example of the templates working against an ODBC/SQL backend is provided using a free distribution (version 1.5) of FireBird (Open Source) Backend.

I installed the SuperServer and ODBC driver on my development machine. 5 minutes? <g>

Then I opened the C55 BST example app, used Roberto Artigas's Dict2SQL template and generated the script for the dictionary.  I asked it to create all the Autonumber generators, triggers, and ascending, descending keys as needed.

Use the Database Management tool of your choice, IBExpert personal edition is free.  I used the Database Workbench in my case.

Several new websites have been created recently on Clarion and Firebird to help you with these steps.

I created a database called BST.FDB and imported the script into it to create the tables and fields.

I had to tweak the database slightly by removing the default values that were used in the clarion dictionary for priming records.

They can remain in the clarion dictionary, but not the backend.  The backend handles the Autoinc.

In my case, I set up an ODBC datasource using the Topspeed driver for the tps data files in the C55 example and used the DataPump included with the DataBase Workbench to suck in my sample data.

Then I set up an ODBC datasource for the firebird server using the default account with password "masterkey".

Then i created a new dictionary in a new directory called FB_BST.dct and ran the Dictionary Synchronizer to import the files. Then I Wiz genned a FB_BST.app.  Little bugger worked right out of the box<seg.>

Then I added some procedures and BST templates and they worked out of the box.<even bigger seg>

All you should have to do to run the example app is install the firebird superserver and client, and create the ODBC DataSource as above, and you can have the example up and running.