Templates, Tools and Utilities
Powerful SQL templates that will speed up your Clarion SQL browses, make coding easier, and much more
The Icetips SQL Templates will make your Clarion SQL database work faster and easier. You can speed up your queries and data transfers, quickly build complex filters, easily access stored procedures and SQL functions, and much, much more.
Active Invisible option makes complex windows with many browses load much faster.
WindowComponent interface implemented, which means that the browse refreshes properly when it should without adding any embedded code.
Filters can be literal strings without the templates quoting the filter, which makes it very easy to construct filters from variables.
Reset fields can be specified. The reset fields trigger a complete refresh of the browse if the value of the reset variable changes.
Records can be primed prior to calling the Prime method and also after calling the Prime method, which means priming can be pruned and groomed exactly to what you need.
Priming includes setting a field to NULL, setting it to a variable or a < value or calling a function to assign it - all from template prompts.
Built in method to call OutputDebugString to set up simple and easy debugging in the classes and in your procedures that use the SQL templates.
The SQL browse templates are compatible with most SQL dialects. They are in use with various backend databases including SQL Server (MS-SQL), Oracle, Sybase, MySQL, PostgreSQL and more. You can also use the SQL Templates with any database that supports ODBC.
You can use the Icetips SQL Browse Templates with Clarion 5.5-8 in the ABC template chain. The control template can be used on any Window procedure to create an SQL browse.
Control Templates, Classes
There are control templates for browses, update buttons, locators, and select button. There are also many extention templates. Please refer to the SQL Template Documentation (below) for more information.
The Icetips SQL Templates comes with a detailed 96 page users guide in PDF format. You can download the documentation for detailed information about how the product can be used (below).
How to buy
8 Files Available for Download for Icetips SQL 6.0 ABC