Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

20 Free SQL stuff Files Available for Download
File Date Description Size File Name
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,301,928 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,971 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,174,631 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,157,115 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,156,290 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,111,492 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,095,485 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.
19890 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.
20047 sqlmaint_copy3.zip
2006-11-09 SQL Database Maintenance Template Version 2.
SQL database maintenance template Version 2. Now supports IDENTITY columns.
19963 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.
14780 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.
18001 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,700 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".
3,607 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,275 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,721 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,001 dct2sql.zip
2004-01-30 How can you connect to an online MySQL database? 488,956 connecting to sql databases online.pdf
2003-07-06 Icetips SQL documentation 1,169,779 icetipscowboysql.pdf
2003-07-06 Icetips SQL documentation 1169779 icetipscowboysql.pdf
 » Log in
User Name:

Password:


No subscription?
Subscribe Now!
Lost Password