Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

23 Free SQL stuff Files Available for Download
File Date Description Size File Name
2016-02-28 Dct2Sql templates - as of February 28, 2016 - Compatible with Clarion 7 - 10
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.
1 DCT2SQL10_20160228.zip
2016-02-18 Dct2Sql templates - as of February 17, 2016 - Compatible with Clarion 7 - 10
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.
1 DCT2SQL10_20160217.zip
2016-02-16 Dct2Sql templates - as of February 16, 2016 - Compatible with Clarion 7 - 10
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.
1 DCT2SQL10_20150809.zip
2011-10-20 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.
1 DCT2SQL_2011-09-02.zip
2010-02-01 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
323 DCT2SQL_C7_2010-02-01.ZIP
2008-08-18 Dct2Sql templates - as of June 19, 2008
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.
1 DCT2SQL-2008-06-19.ZIP
2008-06-09 Dct2Sql templates - as of June 9, 2008
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.
1 DCT2SQL-2008-06-09.ZIP
2008-03-03 Dct2Sql templates - as of March 3, 2008
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.
1 DCT2SQL-2008-03-03.ZIP
2007-12-06 Dct2Sql templates - as of December 6, 2007
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.
1 DCT2SQL-2007-12-06.ZIP
2007-09-04 Dct2Sql templates - as of August 15, 2007
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.
1 DCT2SQL-2007-08-15.ZIP
2006-11-24 SQL Database Maintenance Template Version 4.
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.
19,890 sqlmaint_v4.zip
2006-11-13 SQL Database Maintenance Template Version 3.
SQL Database Maintenance Template Version 3. Added support for descending components of keys.
20,047 sqlmaint_copy3.zip
2006-11-09 SQL Database Maintenance Template Version 2.
SQL database maintenance template Version 2. Now supports IDENTITY columns.
19,963 sqlmaint_copy2.zip
2006-11-08 SQL Database Maintenance Template Version 1.
SQL Database Maintenance Template Version 1. Creates and updates your tables, columns, and indexes at run time based on your Clarion dictionary.
14,780 sqlmaint.zip
2006-11-08 SQL Database Maintenance Template Version 1.1
SQL Database Maintenance Template Version 1.1. Creates and updates your tables, columns, and indexes at run time based on your Clarion dictionary.
18,001 sqlmaint_copy1.zip
2006-03-13 Better SQL and OOP
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.
208 bettersqlandoopforc55andc6.zip
2006-03-12 Class+Template for MySQL
From Dan Pressnell
A class for MySQL page loaded browses for ABC, and a template for "legacy".

Update February 2023: This class still works in the lastest Clarion 10/11 to help performance when loading ABC browses from MySQL/MariaDB.
3 mysqlpageloadedbrowses.zip
2006-03-08 Typical SQL aggregate handling
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.
455 basic_sql_handling_setup.zip
2006-03-06 Create MS-SQL databases
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.
131 create_database_sample_setup.zip
2004-11-15 Roberto Artigas' SQL templates to create SQL scripts from a Clarion Dictionary
New version, November 15, 2004
203 dct2sql.zip
2004-01-30 How can you connect to an online MySQL database? 488 connecting to sql databases online.pdf
2003-07-06 Icetips SQL documentation 1 icetipscowboysql.pdf
2003-07-06 Icetips SQL documentation 1,169,779 icetipscowboysql.pdf

Login

User Name:

Password: