|
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.3 | Yes |
| Clarion 7 - 10 | Yes |
| ABC | Yes |
| Legacy | No |
| Multi-DLL | Yes |
| Source code | Yes |
| Documentation | 96 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 on a window
Filters
Hotfields
Variables
Icons
Conditional icons
Colors
|
|
|
