Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

SQL Browse Templates


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.

Icetips SQL templates buffer the rows read from the database which speeds up the browse as you scroll through it. Once the rows are read in they are not discarded until the browse closes or is re-ordered, unlike ABC browses.



  • Automatic setup for local variables
  • Powerful locators
  • Construct your own select statement
  • Header click sorting
  • Default sort column can be specified
  • Default sort order can be specified
  • Columns can be moved around
  • Call SQL functions to fill columns
  • Call stored procedures
  • Filter entire browse or individual columns
  • Full support for icons & conditional icons
  • Full support for colors & conditional colors
  • Full support for styles
  • Easy to use Style Builder
  • Optional GreenBar effect
  • Supports LazyOpen
  • Characters used to indicate sort order (+/-) can be changed
  • Characters used to indicate the sort column (< and >) can be changed
  • Multiple hot keys can be specified for update buttons
  • Both Runtime and compile time (TRN files) translations supported
  • All Clarion source code - no black boxes

Powerful SQL templates that will speed up your Clarion SQL browses, make coding easier, and much more


Multi-Browse Windows

Active Invisible option makes complex windows with many browses load much faster.

Browse Refresh

WindowComponent interface implemented, which means that the browse refreshes properly when it should without adding any embedded code.

Filters

Filters can be literal strings without the templates quoting the filter, which makes it very easy to construct filters from variables.

Reset Fields

Reset fields can be specified. The reset fields trigger a complete refresh of the browse if the value of the reset variable changes.

Record Priming

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.

Prime Settings

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.

Debugging

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.

SQL Compatibility

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.

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.

And more...

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

The SQL Templates are included in Icetips' high-value Gold Subscription for $299. The SQL Templates may also be purchased separately for just $99.  (Multiple copy pricing is available.)

Compatibility

You can use the Icetips SQL Browse Templates with Clarion 5.5 - 10 in the ABC template chain. The control template can be used on any Window procedure to create an SQL browse.

INFORMATION
Updated: 7-Jun-2021
Clarion 5.5 - 6.3Yes
Clarion 7 - 10Yes
ABCYes
LegacyNo
Multi-DLLYes
Source codeYes
Documentation96 pgs (PDF)

14 Files Available for Download for Icetips SQL 6.0 ABC

File Date Description Size
2021-06-07 Icetips SQL build 2021.06.505.56 (Clarion 11.1)
Build 2021.06.505.56 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 11.1
Release for Clarion 11.1
2,905,144 Download
2018-10-14 Icetips SQL build 2018.10.504 (Clarion 11)
Build 2018.10.504 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 11
Release for Clarion 11
2,896,440 Download
2015-02-24 Icetips SQL build 7.0.497 (Clarion 10)
Build 7.0.497 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 10
Pre-release for Clarion 10
2,878,704 Download
2014-06-03 Icetips SQL build 7.0.496 (Clarion 9.1)
Build 7.0.493 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 9.1
Fix to template - couldn't register
2,876,864 Download
2014-01-29 Icetips SQL build 7.0.493 (Clarion 9.1)
Build 7.0.493 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 9.1
Installer is now compatible with Clarion 9.1
2,602,088 Download
2013-08-02 Icetips SQL build 7.0.492 (Clarion 9)
Build 7.0.492 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - Clarion 9.0
Installer is now compatible with Clarion 9.0
2,594,736 Download
2011-05-04 Icetips SQL build 6.2.481
Build 6.2.481 Compatible with Clarion 5.5, 6.0 to 6.3, Clarion 7.0 - 7.3 and Clarion 8.0
Installer is now compatible with Clarion 8.0
2,509,848 Download
2010-12-21 Icetips SQL build 6.2.477
Build 6.2.477 Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7.0 - 7.3
Installer is now compatible with Clarion 7.3
2,660,936 Download
2010-06-06 Icetips SQL build 6.2.475
Version 6.2.475
Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7.0 - 7.2
2,654,744 Download
2010-03-15 Icetips SQL build 6.2.471
Version 6.2.471
Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7.x
2,386,424 Download
2010-02-15 Icetips SQL build 6.2.470
Version 6.2.470
Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7.x
2,384,312 Download
2009-05-27 Icetips SQL build 6.2.461
Version 6.2.461
Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7
2,286,712 Download
2009-04-15 Icetips SQL
Version 6.2.458
Compatible with Clarion 5.5, 6.0 to 6.3 and Clarion 7
2,230,240 Download
2003-07-06 Icetips SQL documentation 1,169,779 Download

Browse windows:

SQL Browse on a window

SQL Browse

SQL Browse on a window
SQL Browse

Template windows:

General

SQL Browse

Filters
SQL Browse

Hotfields
SQL Browse

Variables
SQL Browse

Icons
SQL Browse

Conditional icons
SQL Browse

Colors
SQL Browse

Login

User Name:

Password: