Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. This version added John Waterhouse’s ORACLE modifications.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. This version is compatible with Clarion 7 - 10 and has better support for Clarion 10 than the one from yesterday, February 16, 2016.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. This version is compatible with Clarion 7 - 10.

This utility creates an .EXP file from a class .INC file so it can be included in a DLL export. See Icetips Utilities Include Export Files template for an easy inclusion of .exp files in your application.

Dct2Sql templates - as of September 2, 2011 - Compatible with Clarion 7 and 8

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. According to Roberto this build includes updates to the PostgreSQL and MySQL templates. This version is compatible with Clarion 7 and 8.

Power Toolbar demo install. The demo installs a exe and tps file to demonstrate the Power Toolbar product. This demo is supplied as a demo app with the product. It is compiled local so it does not need any runtime dlls.

Dct2Sql templates - as of February 1, 2010 - Compatible with Clarion 7.x

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. According to Roberto this build includes updates to the PostgreSQL and MySQL templates. This version is compatible with Clarion 7.x

This is a DLL, with source, that we use to call from our templates using #RUNDLL. It is not documented apart from the included ITRun32.cpp source code. You can use this file for your own templates. Redistribution is prohibited without a permission from Icetips Creative, Inc.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. According to Roberto this build includes updates to the PostgreSQL and MySQL templates.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. According to Roberto this build includes two new PostgreSQL utilities and the UTIL_DictionaryFiles4 which you might want to look at. And Jimmy Rogers contributed his Firebird conversion templates to the collection.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. According to Roberto this build includes changes to PostgreSQL and Mimer templates and a new Pervasive template.

List all Special Folders (CSIDL) on your computer. This program can be installed on any computer to see and print a list of all the CSIDL folders on the computer. This can save a lot of time to figure out where what folders are.

Bo Schmitz has put together a little global template to add Manifests to older
versions of clarion using code "borrowed" from the C6 template chain. (Xp and Vista, and compiling inside exe) Tested and works on C55. Didn't test on C5 and C4.

This demo install shows what can be done with our new Icetips Magic Locks. This demo uses Icetips Magic Locks version 1.1 and should work flawlessly on Windows Vista. The demo comes with an introduction video with information about how to use the Magic Locks.

Roberto Artigas' DCT2SQL templates are invaluable when you need to create SQL scripts to create a database based on a dictionary. It supports various SQL dialects, including MS-SQL, Sybase, MySQL, Mimer, Oracle, Firebird, Interbase and PostGreSQL. The date in the template is April 28, 2007, but we received this on August 15, 2007 from Roberto.

This small demo, using the invoice.dct from the Clarion 6.3 examples, demonstrates basic use of the Page of Pages class in the Icetips Utilities. The zip includes app, dct, tps and other necessary files. It also includes a locally compiled exe.

SQL Database Maintenance Template Version 4. Rewritten to use a locally declared file buffer for sending SQL. Eliminates need for opening and closing each file created, and improves performance. See documentation.

From Dan Pressnell
This app shows some typical SQL handling in getting aggregate data (group by, count, sum, etc.)
It also shows how the equivalent of such SQL things can be handled with non-SQL systems, such
as TPS files, by using a little code for queue processing. See the two "BrowseByCity" procedures,
which in this case display exactly the same information to the user.

Everything is Clarion straight out of the box, no add-ons, no 3rd-party tools.

About this data file: This is an old database of Texas schools that I have had for some time that
was downloaded from the web. I have removed phone numbers and email addresses.

From Dan Pressnell
This zip has an APP and a DCT that illustrates how Clarion can be used to connect to a MSSQL server, create a database if it doesn't exist, and create tables and indexes in the database if they don't exist. Sort of a "program as its own DBA" kind of thing.

From Icetips Software
This template makes it possible to add a call to a single procedure from every window procedure in your application. It has 6 possible embed points ranging from "Start of Procedure" to "After Window Open Event". Works in ABC only.