Icetips Runtime Libraries used by templates and installs.

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.

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

Demo program for version 2.7. Includes Report Writer report and printing to PDF, HTML, XML and Text files using the report target classes.

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.

ITRun shows how to run programs and elevate them properly under Vista or Windows Server 2008. It is based on some methods in our Core and Shell Classes in the Icetips Utilities.

PDF Documentation (189 pages) for version 1.1.2319

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.

This is an introduction video for Icetips Magic Locks 1.1

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.

16 page PDF documentation for the Icetips Magic Locks version 1.1

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.

Included is a Clarion 6.3 app, and two sourcefiles, .clw and .inc for the test class. This demonstrates a simple method to dynamically load a dll at runtime instead of using a LIB file.

This install updates the WIN.INI file and the PATH environment variable to the correct values for Clarion 6 install.s

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.

This zip contains the people.app, people.dct and people.tps files. Unzip into an empty folder and load the people.app. Compile and run. Use "Browse | Update People" to access the browseless form.

We use Borland C++ compiler/IDE to compile the code but it should compile in other C++ as well. This code is specifically written to use with the #RUNDLL template statement.

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.

SQL Database Maintenance Template Version 3. Added support for descending components of keys.

SQL database maintenance template Version 2. Now supports IDENTITY columns.

SQL Database Maintenance Template Version 1. Creates and updates your tables, columns, and indexes at run time based on your Clarion dictionary.

SQL Database Maintenance Template Version 1.1. Creates and updates your tables, columns, and indexes at run time based on your Clarion dictionary.

Documentation for Icetips Previewer version 2.4 released on November 1, 2006. This is a 90 page PDF manual.

From Icetips Software
This is a useful to create simple RTF to plug into RTF controls. Now comes with app in 6.3 that has same functionality, but not the same look and feel.

From Dan Pressnell
This install contains the files that went with the Better SQL and Better OOP series of articles. Works with Clarion 5.5 and Clarion 6.x.

From Dan Pressnell
A class for MySQL page loaded browses for ABC, and a template for "legacy".

From Dan Pressnell
This app shows a better way of handling break condtions in reports that have a large amount of hand coding. APP+DCT+TPS files in a zip file.

From Dan Pressnell
The original CW ODBC code that was mentioned in Dan's Better SQL series. This is now packaged as an APP, for easier maintenance. It requires the dp_class.tpl template.

From Dan Pressnell
The original CW ODBC code that was mentioned in Dan's Better SQL series. This is now packaged as an APP, for easier maintenance. It requires the dp_class.tpl template.

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.

This is for both Clarion 5.5 and Clarion 6.x.

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 it's own DBA" kind of thing.

From Dan Pressnell
This is a small class which allows Clarion's IDE to be used to create classes, so that the class source stays in the app tree, and is generated along with the rest of the app.

There is a demo app showing how it's used.

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.

From Icetips Software
DLL to use to create a MD5 hash from strings (CStrings). Works well with Clarion and is 100% compatible with MD5 created with PHP.

Version 1.05
Compatible with Clarion 4, 5 and 5.5

43 button images in bmp, gif or jpeg file formats. See Magic Buttons Screenshots for more details.