ExplorerBrowse itself can also be extended by adding a locator template called ExplorerBrowseLocatorControl and a query control called QueryParsingFilterControl. Examples of both are provided. Ancillary templates called HandyQueryProcessLimiter and HandyQueryReportLimiter allow you to pass queries directly from the browse to a report or process via a window button template called HandyQueryProcessButton. See the procedure called Demobrowse4 for examples of this powerful feature.

The major CHT classes involved are: HNDBrowse, HNDBrwFilter and HNDParse. Subscribing developers should take some time to study the header files for these three classes to become familiar with available properties and methods in order to gain the maximum amount of utility from them.

The browse-marking templates involved are: HandyMarkerBrowse and ListBoxBrowseExtender. HandyMarkerBrowse extends a normal ABC browse template while ListBoxBrowseExtender extends a standard list box. They are separate browse-producing templates with different feature sets and some overlapping features.

Other marking-related templates ancillary to these two allow you pass marked records to processes for export to HTML, TEXT, FILE, EXCEL and print reports limited to only the records marked in your browse. These templates are: HandyMarkerBrowesProcessLimiter, HandyMarkerBrowseReportLimiter, HandyMarkerBrowseProcessButton and HandyMarkerBrowseReportButton.

A ancillary template called HandyMarkerBrowseSetsControl allows you to store and recall sets of marked records by name.

Some examples of the things illustrated:
Creating nested directories
Copying and moving files
Finding the directory of a file using only its file name
Determining drive size and space remaining, the number of drives and drive types
Determining the unique ID of a system's hard disk
Launching Windows File Explorer from inside your app
For file copying, moving, erasing, renaming in bulk see HNDCPYDM.APP.
For file compression and decompression in bulk see HNDZDEMO.APP.
For file containerization and decontainerization in bulk see HNDSETUP.APP.

The HandyAddressControl Template provides three free-form address capture controls similar to those found in Microsoft Outlook. This set of controls allows users to type their name and address in a more-or-less free form style while still allowing the developer to capture address components in separate data base fields.

The HandyRulerControl Template provides horizontal and vertical rulers combined with an image control to provide scaling for drawings and images.

The HandySliderControl Template provides a standard MS Windows slider control that can be used in a variety of settings from browses to image scaling.

As of the O7B Build some extra code has been added to the underlying classes to allow the address control to remain completely empty if so required.

This template instantiates an OOP class called HNDRegistry which deals exclusively with reading, writing and deleting from the MS Windows (tm) registry. For a full listing of methods and properties available in this class open the class header module called HNDREG.INC.

This application will let you test reading, writing and deleting registry entries on your system. Follow the instructions on the "Registry Demo" window.

HNDWindow has numerous window-related capabilities some of which are demonstrated in this application. Other templates that create (or use) instances of HNDWindow and use other features of that class are:

* HandyTellMeControl - scrollable text message areas
* VisitMeControl - window hot links to your website.
* VisitMeControl_EWF - window hot links advanced
* HandyMailMeControl - window hotlinks for email
* HandyMailMeControl_EWF - window hotlinks for email advanced
* HandyHelpMessageBox - easy popup message boxes
* ApplicationImagesEx - image management application global
* ProcedureImagesEx - image managment procedure specific
* ExtendedEvents - trap and act on extended MS Windows Events

This application has a companion called hnd8a.app which must also be compiled in order to illustrate inter-application messaging and data transfer. If you're using the source versions of CHT's example applications, make sure to compile hnd8.app before running this one.

It intercepts window messages from HND8.APP and illustrates programmatic control of one application by another simply by passing window messages between applications.

This splash screen is only added to the application for documentation purposes. It never displays as the application runs under the control of HND8.APP.

Any questions, free free to ask on the CHT Forum http://support.cwhandy.ca/LOG$

It checks the state of one function and one property in the ABUTIL library. Remove is changed to VIRTUAL,PROTECTED from non-virtual and CritSect is changed from PRIVATE to PROTECTED.

This allows CHT to override all requisite ABC INIManager functions to allow redirection of INI/Registry I/O to a dictionary table owned by the application.

This application also calls REGASM.EXE to register several NET dlls for COM interoperability with Clarion 6 and Clarion 7. These are at time of writing:

HNDNETSMTP.DLL
HNDNETZIPPER.DLL
HNDNETDATETIME.DLL
HNDNETFTP.DLL

To register these DLL's manually using this application call the app from the DOS prompt as follows: HNDABCHK /REGASM

Your hardware O/S must have at least Windows FrameWork 2 installed for these NET DLLs to become correctly registered.

This splash screen is only added to the application for documentation purposes. It never displays as the application runs hidden from our template.

Any questions, free free to ask on the CHT Forum http://support.cwhandy.ca/LOG$

The CHT query parser has the ability to generate optimised NATIVE SQL directly from your real-language queries. The SQL is then sent to your data base using View{{PROP:SQLFilter} rather than via ABC.SetFilter(). In the O8A1.0 build we've added an optional QUERY BUILDER (OBJ.QBInterface()) to the ? button of the QueryParsingFilterControl template.

The CHT-generated SQL appears in the WHERE clause component of the SELECT string sent to your data base. The chief advantage of this is speed. Clarion's file drivers do not always translate clarion filter strings into effective SQL. In some cases, depending how complex your query, ABC.Setfilter() causes the driver to literally read large portions of the data base, forcing the driver to manage filtering rather than letting the data base handle it.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

A CHT control template called HandyComAnimationControl helps you drop this control onto any application window and instantiate the Clarion-style interface to the COM IAnimation control.

Any questions, feel free to ask: http://news.cwhandy.ca

The application also generates an ordered HTML version of this information for use in our website. Application listings are generated in application name order with a category index before the text area.

This application is available to CHT users who want to handle application summary descriptions from splash screens in a similar manner. See the AACHTControlPanel Splash Screens dialog for control of the splash screen export feature.

Key templates illustrated: ExplorerBrowse, QueryParsingFilterControl, EmbedDiskFunctions, EmbedFilterFunctions, HandySourceProcedure and EmbedStandardWebPageHeader.

Any questions, feel free to ask: http://news.cwhandy.com

Settings include, the ability to: 1) turn auto-backup on or off, 2) modify the target backup directory, 3) maintain, delete and zip backup files.

This application works with both C6 and C7 when compiled in the respective compiler.

Any questions, feel free to ask.

The application runs as a service to back up user-designated directories using file-limiting masks at user-designated times. A configuration file called HNDBACKUPSERVICE_A.INI provides a backup time, a target copy directory and a backup hzo directory. Up to 100 source backup descriptions that include source directory and file-mask are possible.

To install the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /IS
To start the service - once installed - from the DOS prompt type:
HNDBACKUPSERVICE_A /SS
To stop the service from the DOS prompt type:
HNDBACKUPSERVICE_A /STOP
To remove the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /RS

The application runs as a service to back up user-designated directories using file-limiting masks at user-designated times. A configuration file called HNDBACKUPSERVICE_A.INI provides a maximum of 10 backup times and 100 backup descriptions that include source directory, file-mask, target directory.

To install the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /IS
To start the service - once installed - from the DOS prompt type:
HNDBACKUPSERVICE_A /SS
To stop the service from the DOS prompt type:
HNDBACKUPSERVICE_A /STOP
To remove the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /RS

The application runs as a service to back up user-designated directories and sub-directories. A configuration file called HNDBACKUPSERVICE_CD.INI provides a backup time, and a target CDROM drive number. Up to 100 source directories may be listed.

To install the service, from the DOS prompt type:
HNDBACKUPSERVICE_CD /IS
To start the service - once installed - from the DOS prompt type:
HNDBACKUPSERVICE_CD /SS
To stop the service from the DOS prompt type:
HNDBACKUPSERVICE_CD /STOP
To remove the service, from the DOS prompt type:
HNDBACKUPSERVICE_CD /RS

The Clarion Handy Tools offer a very broad spectrum of email support in the form of templates, OOP classes, examples and Jump Start procedures.

Any questions, feel free to ask: news.cwhandy.com

This client application serves to illustrate how to log in and then make a variety of data requests and data updates from a Clarion client application using the IE browser class called HNDInternetExplorer and a template called HandyComInternetExplorer.

Any questions, feel free to ask: news.cwhandy.com

For example:
HNDBUILDVIDEOLIST d:\videos\ 80

The applications scans this target directory for all .WMV files and produces VIDEONAME.HTM and VIDEONAME.JS that can play a video with that name from your web server. The models for all generated files are located in \3rdparty\hnd\model\ if you would like to modify them. Remember that the provided model files are shipped by CHT with each update so you'll need to modify and save them with a name of your own and change this application to use your versions of all model files.

The application also produces a HNDMEDIAPLAYER.NDX file which may be used by CHT player application HNDMEDIAPLAYER.APP as a downloadable video index. Complete the description portion in each video entry and save the file back to the server. Next time you run this application to create a new index in order to include more videos, the description entries from the existing HNDMEDIAPLAYER.NDX file are copied forward into the new index, where applicable.

To further adapt this application for your own use, open the MAIN procedure in the Clarion Embeditor and follow the comments provided.

This splash screen is only added to the application for documentation purposes. It never displays as the application runs hidden from our template.

Any questions, free free to ask on the CHT Forum http://support.cwhandy.ca/LOG$

The application also includes a set of separate attachment encryption/decryption procedures. While attachment encryption is invoked on the fly as you send mail, the decryption procedure can be used to unencrypt attachments received from this application.

The Clarion Handy Tools offer a very broad spectrum of email support in the form of templates, OOP classes, examples and Jump Start procedures.

Any questions, feel free to ask: news.cwhandy.com

As usual, subscribers with a SOURCE code subscription receive the code module as well as the header. DLL version subscribers receive only the header module and the class code is in one of the CHT DLLs.

The application illustrates the syntax used to call many of the functions available in the HNDDates class. There are also two separate implementations of the calendar showing how you can modify the look of the CHT calendar by calling methods like OBJ.SetCalendarIcon() and embedding new calendar image properties in that method.

Extension template EmbedCalculatorFunctions attaches a CHT class called HNDCalcControl to your application procedure, making its functions available to the procedure.

Control template HandyCalcEntryControl_ECF drops an entry control and a button on your procedure window. These controls work in tandem. A numerical value in the entry control is passed to the calculator - accessed via the button control - and the calculator passes a calculated result back into the control. A thread option on the tempate provides for passing data back to the entry control without closing the calculator, which can be left open on top of the application window.

HandyCalcTapeEntryControl_ECF works similarly. It provides also a visible calculator "tape" simulation. Contents of the tape may be captured in the background for use elsewhere or for filing or printing. The tape calculator uses a graphic interface that may be interchanged for different languages. Developers requiring language-specific symbols should contact CHT for a custom interface graphic if the one for their language is not available.

Any questions, feel free to ask them on the CHT forum.
Gus M. Creces
The Clarion Handy Tools Page

Any questions, feel free to ask: news.cwhandy.com

With this application it is possible to select (or drag and drop) one or more directories to be backed up to CD ROM. Note that sub-directories of selected directories are automatically backed up too.

Target CDROM disks may be CD-R, CD-RW, DVD-R, DVD-RW and other, less commonly used variations of these.

With this application it is possible to select one or more directories to be backed up to CD ROM. Note that sub-directories of selected directories are automatically backed up too.

Once directories are inserted to the "Backup Directories" list, it is possible to include or exclude any directory from the backup list by checking or unchecking, respectively.

Target CDROM disks may be CD-R, CD-RW, DVD-R, DVD-RW and other, less commonly used variations of these.

The server, HNDCLIENTSV.APP, is an example Client Server with no data views, so it is expected that the developer will use that server (saved under a different name) to act as the basis for his Client server views.

Once that server contains at least one completed data view, then this application (saved under a different name) can begin to act as the basis for an HTTP client that connects to your new server and displays its views.

Any questions, feel free to ask: news.cwhandy.ca

The server, HNDCLIENTSVLEAN.APP, is an example Client Server with no data views, so it is expected that the developer will use that server (saved under a different name) to act as the basis for his Client server views. This "lean" version server has had all non-essential components removed and focusses entirely on the CHT templates required to build a CHT Web Server.

Once that server contains at least one completed data view, then this application (saved under a different name) can begin to act as the basis for an HTTP client that connects to your new server and displays its views.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

The server, HNDCLIENTSVLEAN1VIEW.APP, is an example Client Server with one back-end data view built on a variation of a .TPS based demo file called "People" used in other CHT demo applications.

Use this Client and it's accompanying server as a study example when you begin building your own CHT Web Client Server applications.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

This server application has a matching demonstration client called HNDCLIENTCL.APP. Since the server has no views for the client to connect to, this client contains only basic connection capability.

This server is able to provide both compressed and encrypted data streams consisting of browse data, form data, report and process data based on interactive queries placed from the client side targeted at pre-determined data views (single or multi-table) that the developer adds into the server.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

This special "lean" version has had all non-essential componentry removed and focusses entirely on CHT templates and classes required to build a fast, efficient CHT Client Data Server.

This server application has a matching demonstration client called HNDCLIENTCLLEAN.APP. Since the server has no views for the client to connect to, this client contains only basic connection capability.

This server is able to provide both compressed and encrypted data streams consisting of browse data, form data, report and process data based on interactive queries placed from the client side targeted at pre-determined data views (single or multi-table) that the developer adds into the server.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

The developer can add multiple server-side views to a server of this sort without having to design any of the server "plumbing" such as configuration or server client maintenance.

This server application has a matching demonstration client called HNDCLIENTCLLEAN1VIEW.APP, which illustrates connecting to this server and browsing the people file across the web.

This server is able to provide both compressed and encrypted data streams consisting of browse data, form data, report and process data based on interactive queries placed from the client side targeted at pre-determined data views (single or multi-table) that the developer adds into the server.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

The application also generates an HTML version of this information for use in our website.

Key templates illustrated: ExplorerBrowse, QueryParsingFilterControl, EmbedDiskFunctions, EmbedFilterFunctions, HandySourceProcedure and EmbedStandardWebPageHeader.

NOTE: At time of release of this app, Feb 1, 2006, not all embedded documentation in the CHT classes is complete. We expect that phase one, the class-purpose component will be complete by early March 2006 and the method-by-method component for primary methods, will be complete by early summer 2006.

Any questions, feel free to ask: http://news.cwhandy.com

A CHT control template called HandyCOMCalendarControl helps you drop this control onto any application window and instantiate a Clarion-style interface to the OCX ICalendar control.

Any questions, feel free to ask: news.cwhandy.com

They come as part of a complete set of Clarion "Extensions " including:
Browse Enhancements, FTP, Email, Windows API, Browse and Report Filtering, Windows Sockets and more.

This compile manager application is complete in its own right.
However, it requires that the HNDTOOLS.TPL (template) be present in your Clarion template directory and a CHT template called HNDCMPControlPanel be applied to your applications. This template and file are supplied only to full-fledged CHT subscribers.

Any questions, feel free to ask: news.cwhandy.com

It allows you to establish ahead of time, or even after the fact, many of the default settings required for templates like ApplicationImagesEx, ProcedureImagesEx, EmbedWindowFunctions and more. You can change them easily without having to open your application and navigate to individual template dialogs to change settings. Once a style scheme has been applied via this configuration tool, a simple recompile of your applications reflects the newly applied design.

All template dialogs affected by the configurator can be set to incorporate its settings, or to override them with values unique to the application.

Several default style schemes are provided and the developer can easily add and modify his/her own designs as required. Any questions, feel free to ask: news.cwhandy.com.

Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.com
news.cwhandy.com

The template provides two interface controls, a string control for messages and a progress control to indicate progress through bulk zip and unzip operations. Since this is a "Control" template it operates from a window. If a silent, or invisible zip operation is required, simply hide the window. Operations provided are: bulk directory zip with mask, bulk directory unzip with mask, single file zip, and single file unzip.

The template incorporates a CHT COM Zipper Wrapper called HNDComZipClass into your procedure. See HNDZIPPR.INC, HNDZIPPR.CLW and HNDZIPPR.TLB to study the header, code module and method interfaces respectively.

Any questions feel free to ask.

Any questions, feel free to ask: news.cwhandy.com

To do achieve this, the template invokes a CHT COM wrapper class called HNDDigitalClockClass which loads and calls into a CHT COM DLL called HNDDGTLCLOCK.OCX.

No coding is required. Standard Clarion sizing and hiding properties apply to the digital clock container.

Any questions, feel free to ask: news.cwhandy.com

Following Clarion's browse/form paradigm, when the user clicks on any of the listed files in the browse, a form opens up and presents details about that file as well as a download link. Users click on the link to download the file or on a button to close the form and return to the browse.

This application is entirely template-built and contains almost no hand-embedded code.

A new feature on the HandyMarkerBrowseProcessButton and HandyMarkerBrowesReportButton templates lets you opt to have the marked record set translated into an SQL IN(x,y,z) request to be sent to a report or process rather than a queue of marked records. Default behavior is as before, to send a queue.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. You do not need a copy of the Microsoft Access to test this, and a copy of NORTHWIND.MDB is included in the install. The application will find the data base and register it with ODBC if not already registered.

In this case, we're autocompleting a "State Name" field from a file called hndstatesnew.tps. By simply typing 3 or 4 letters into this field a dropdown appears which displays the closest matches for the typed value. By continuing to type beyond 4 characters a matching value is brought into your autocomplete control.

Alternatively, with the down arrow key, you can scroll down into the dropdown control to select one of the values that appear there.

Adding to the autocomplete file: If you type a unique value and press CtrlEnter, the entered value is added to the autocomplete source file.

Deleting from the autocomplete file: If you bring an existing value from the autocomplete file into the autocomplete entry control and press CtrlDelete you are able to delete a value from the autocomplete source file.

The Clarion Handy Tools Page

A CHT control template called HandyCOMDatePickerControl helps you drop this control onto any application window and instantiate a Clarion-style interface to the OCX IDatePicker control.

Any questions, feel free to ask: news.cwhandy.com

HNDIDial can be used alone, as it is here, or in combination with other classes. The CHT tool kit classes, HNDIMail, HNDInetFTP and HNDHttp automatically derive HNDIDial for you in order to handle connectivity issues.

See the header file HNDIDIAL.INC for a list of properties and methods available.

CHT's Event Logger Control provides an easy-to-use COM interface inside your application procedures for writing Events, Errors and Warnings to the SYSTEM APPLICATION LOG where they can be found and read using EVENTVWR.MSC.

See HNDEVEER.INC, HNDEVEER.CLW and HNDEVEER.TLB to study the header, code module and method interfaces respectively.

Any questions, feel free to ask: news.cwhandy.com

The fundamental principles and practices of this server's design are pure ABC. If you understand Clarion, and ABC Object Oriented Principles, you can duplicate a server of this type using The Clarion Handy Tools. It may be used as the basis for building forward any other type of "Browser" server design or simply as a model on which to base a new design.

Web scripts constituting the "user interface" for this "Browser" server are built, as usual, using CHT Scripter. These scripts are fully previewable and are live-data-interactive during script modification and testing.

CHT Servers of this type do not rely on any generic web server software like Microsoft Internet Information Server. Our servers tie directly into the TCP/IP libraries built into the Windows NT/XP/Vista operating systems. Beyond that, all Internet listening, sending activities, data packaging, compression, encryption and so forth are written in Clarion OOP source code available as part of CHT's standard installation.

Principle server templates in use are: EmbedBrowserServer and BrowserServerInitializationControls, accompanied by a group of page-builder templates that are able to generate XHTML or pure Javascript Data Objects. Included with the CHT Tool Kit is a multi-function editor/scripter (HNDSCRPT.APP) which is used to design the client-side/browser side pages and forms, including CSS (Cascading Style Sheets) and JS (Javascript) Subroutines.

A CHT control template called HandyComMapiControl helps you drop this control onto any application window and instantiate a Clarion-style interface to this COM Mapi Email control.

Any questions, feel free to ask: news.cwhandy.com

Please note, that the code in the EntryPointMain() procedure has very little to do with file to blob or blob to file. This code looks up a file name to be sent to a blob and manages the data base that stores the blob record. Your blob data base may look nothing like the file ZStore that we are using here.

The salient point is that when calling the functions JumpStartFileToBlob() and its inverse, JumpStartBlobToFile(), you are responsible for creating, fetching and saving the data base records in the blob-containing data table. The functions provided, will insert the files to, and extract files independently from, your blob record. Data base I/O is up to you. However the I/O required is standard ABC stuff which you should already know how to do.

We have demonstrated here a couple of HNDDisk class functions to help us with our popup menu, when someone selects a file to be restored or deleted, for example. These have no direct relationship with the two blob functions being demonstrated.

Any questions, feel free to ask: news.cwhandy.com

This special "lean" version has had all non-essential componentry removed and focusses entirely on CHT templates and classes required to build a fast, efficient CHT secure file client.

This client application has a matching demonstration client called HNDFILESERVERLEAN.APP which is enabled to provide secure upload and download services.

This client is able to provide both compressed and encrypted file movement services without requiring either pre-compression or pre-encryption of the upload or download files.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

This special "lean" version has had all non-essential componentry removed and focusses entirely on CHT templates and classes required to build a fast, efficient CHT Secure File Server.

This server application has a matching demonstration client called HNDFILECLIENTLEAN.APP which includes upload and download procedure examples.

This server is able to provide both compressed and encrypted file movement services without requiring either pre-compression or pre-encryption of the upload or download files.

This application is entirely template-built and jumpstart-built and contains almost no hand-embedded code.

These extension/control templates provide TCP/IP connectivity with a browser or client application. In this particular example, application functionality has been limited to acting as an HTTP file transfer server. It requires a file transfer client to interact with it. Two separate demo client applications are provided to subscribers: HNDFLCLN.APP and HNDLIVUP.APP. Another client application called HNDHTGT.APP illustrates making on-the-fly file requests from this server using the HNDHTTP and HNDHTTPClient classes.

A Jumpstart Template is also provided to help you get started with unique-to-you implementations of this server. Or, easier still, use this server as a starting point for your next server project.

The server maintains complete control of which files and directories are visible to the client. File transfers are optionally compressed and/or encrypted at the request of the client application.

This application is entirely template-built and contains almost no hand-embedded code.

Using this template, developers can play and control Macromedia .SWF, "Flash" files on any Clarion window. This specific application enumerates a set of .SWF files provided by CHT, which teach various aspects of The Clarion Handy Tools Toolkit. Files can be selected from a dropdown. A downloader jumpstart is included to help you download all free CHT help videos. The server in use at our end is HNDFILSV.APP, unmodified from the one shipped as an example in our toolkit.

The Flash wrapper class is located in modules HNDFLASH.INC, HNDFLASH.CLW and HNDFLASH.TLB. The template incorporates the main wrapper class HNDFlashClass and initiates it correctly. Load, run and control code is embedded.

Any questions, feel free to ask: news.cwhandy.com

This combination of HTTP Client and Server are intended to take the place of FTP file transfer, providing much more secure and speedy file transfer services in both directions.

Any questions, feel free to ask: news.cwhandy.com

The application communicates with the CHT's Forum Login Page's DOM (Document Object Model) using methods provided in CHT class, HNDInternetExplorer.

CHT Forum Login information is assumed to already be in your system's registry, because your system has been configured for The Clarion Handy Tools by our WEBUPDATER tool.

Any questions, feel free to ask: news.cwhandy.com

Use it to periodically back up your CHT files to the standard 3rdparty directory or to back up before a WEBUPDATER session. A pre-built sync file called hndfsyncc60.tps has been provided for this purpose.

This application illustrates the kinds of things that can be done with several CHT templates used in combination.
The major templates used are:
* EmbedDiskFunctions - to attach the HNDDisk class
* ExplorerBrowse - to attach the HNDBrowse class
* EmbedWindowFunctions - to attach the HNDWindow class

Any questions, feel free to ask: news.cwhandy.com

To install this service application, at the DOS prompt type:
HNDFSYNCSERVICEDEMO /IS or /INSTALL

To start the service once installed, at the DOS prompt type:
HNDFSYNCSERVICEDEMO /SS or /START

To stop the service once installed, at the DOS prompt type:
HNDFSYNCSERVICEDEMO /SP or /STOP

To remove the service once installed, at the DOS prompt type:
HNDFSYNCSERVICEDEMO /RS or /REMOVE

See HNDSERVICEUP.APP and HNDSERVICEUPREMOTE.APP for examples of how to control and configure this service remotely from another application.

This application starts with it's window minimized and hidden. It's application icon appears on the Windows Task Bar from which it can be commanded. By unchecking the "Application In Tray" switch on the EmbedWindowFunctions template in the main procedure, this application can be made to run completely hidden, while still being configured remotely from HNDSERVICEUPREMOTE.APP or HNDSERVICEUP.APP.

Any questions, feel free to ask: news.cwhandy.com

* EmbedInternetFTP (parent template)
* HandyFTPInitializationControls (gather logon and user information)
* HandyFTPLocalFilesControls (gather upload file information)
* HandyFTPLocalFilesULControls (upload files control panel)
* HandyFTPRemoteFilesControls (gather download file information)
* HandyFTPRemoteFilesDLControls (download files control panel)

Note that the application can be easily rebuilt for developer customization with the CHTJumpStartProceduresUtility template. Navigate to the FTP Functions tab and select item four, "FTP Wizard".

This demo is a fully functional FTP application with file upload and download capabiltity, proxy support, directory listing and creation, file deletion and moving. While this application shares the features of many commercial FTP applications, it alone uses the CHT query control which allows you to filter your upload and download file lists and create recallable queries that really boost your productivity.

The application will autorun and autostart if you want it to. Our design allows you to process the messages found and copy the attachments to a subdirectory of your choice. CHT subscribers with the source code to this application can easily rework the message processing loop to act upon some text found in the message subject or message body.

Major templates in use on this application:
* EmbedMapiEmail - attach email classes to your application with full embedding
* ListBoxBrowseExtender - browse re-order and record features on standard listbox
* QueryParsingFilterControl - real language queries to limit your email messages during an inbox scan

HNDGMAILEXPLORER.APP applies primarily a CHT template called HandyComInternetExplorerControl. The template has been configured with specific web form settings that allow it to insert information directly into the web page variables having to do with login. The application communicates with the Gmail login page's DOM (Document Object Model) using methods provided in CHT class, HNDInternetExplorer.

Any questions, feel free to ask: news.cwhandy.com

HNDGOOGLECALENDAREXPLORER.APP applies primarily a CHT template called HandyComInternetExplorerControl. The template has been configured with specific web form settings that allow it to insert information directly into the web page variables having to do with login. The application communicates with the Google Calendar login page's DOM (Document Object Model) using methods provided in CHT class, HNDInternetExplorer.

Any questions, feel free to ask: news.cwhandy.com

This particular demo application runs as a Windows service that enables a set of system-wide hot-keys that launch a variety of CHT support applications as follows:

<9> **** Getting CHT Help (F5 Key) ****
F5 Key<9>= Restore or minimze web-service window
Shift-F5<9>= CHT Video Education Player
Ctrl-F5<9>= CHT Flash Help Player
Alt-F5<9> = CHT Help File Launcher
CtrlShift-F5 = CHT Video Education Web Page

<9> **** CHT Forum Access (F6 Key) *****
F6 Key<9>= CHT Hybrid Web Client
Shift-F6<9>= CHT Support Forum Client
Ctrl-F6<9>= CHT Support Forum Via Browser

<9> **** CHT Installation And Update (F7 Key) ****
F7 Key <9>= CHT Webupdater
Shift-F7<9>= CHT Webupdater Download Page
Ctrl-F7<9>= CHT Installation Tuner

<9> **** CHT Development Utilities (F8 Key) ****
F8<9>= CHT Compile Manager
Shift-F8<9>= CHT Color Configurator
Ctrl-F8<9>= CHT Toolkit Synchronizer
Alt-F8<9> = CHT Web Scripter

<9> **** CHT Other Utilities (F9Key) *****
F9<9>= CHT Installation Containerizer
Shift-F9<9>= CHT FTP Wizard
Ctrl-F9<9>= CHT Handy Zip'N Email
Alt-F9<9>= CHT Handy Zip'N HTTP Post
CtrlShift-F9 = CHT Handy Zip'N FTP

The application has configuration settings that allow you to extract email headers only - name and email address - if all you want to do is build an email mailing list. You also have the option of extracting multiple message bodies and joining them to the email address from which they were mailed. A third option allows you to store the attachments from your emails in a binary attachment file joined to the message body.

The bulk mailer allows for bulk, same-to-everybody emails using blind carbon copy (BCC), or individually-tailored emails using susbstitution tokens ~NAME~, ~CONTACTED~, ~ADDRESS~.

The generic template EmbedObject attaches a less-often-used class called HNDIScavange. This class, which has no high level, programmer interface template of its own, provides email address recovery and storage services by interacting with HNDIMail. The BccEmailer and OneToOneEmailer procedures each apply separately an instance of the InstantOutlookMail template to provide bulk-mail functionality.

Gus M. Creces
The Clarion Handy Tools Page - www.cwhandy.com

The application can be pre-configured to back up a particular directory using a file mask that describes the files to be backed up, resulting in a standard zip file that can include source subdirectories right inside the zip.

An HTTP configuration dialog lets you preconfigure a target web server (IIS-type or CHT-type) and a web subdirectory to accept your zip file.

Once configured, your application can build a backup with one button click and POST it to a web server with a second click.

Any questions, feel free to ask.

The two key procedures used here to PUT and GET files via FTP are available for auto creation by our CHTJumpStartProceduresUtility template, under the "FTP Procedures" tab.

This template is available from the global AACHTControlPanel template using the "JumpStart Procedures" button or via the Application -> Template Utility -> CHTJumpStartProceduresUtility.

Both procedures accept variable or constant parameters providing:
1) File Name
2) Url
3) User Name
4) Password
5) Remote Directory
6) Local Directory

The GET Procedure optionally returns the Date, Time and Size of the returned file.

First, the server provides a web browse and form that let you choose one of three CHT versions and the associated installer(s).

Second, the server provides authentication for the downloaded installers, connecting current subscribers and rejecting expired subscribers. When a current subscriber connects via the updater, a list of current installation HZOs is provided from a standard .TPS or SQL file that you control. The installer can use this list to download those files for which CRCs are different from local containers it may have present.

This application first connects to HNDFILSV.APP to download an installation files list. Next it downloads the listed files and places them in the designated directories below the installer's configured target directory. Files are only downloaded when the CRC value provided for any file is different than the CRC of the file already installed.

The server auto-encrypts and auto-compresses files at the request of this client and files are auto-decrypted and auto-decompressed on arrival. Replaced files are copied to the backup directory before replacement is made.

A configuration procedure called JumpStartHTTPLoginConfigShort() is provided in order to change the installation server as well as the local target and backup directories. The installer always recalls it's last installation log from the config menu.

Any questions, feel free to ask: news.cwhandy.com

This application downloads and installs three standard CHT .HZO container files built with another CHT demo application called HNDSETUP.APP. All of these installation containers contain compressed material (mostly images) and one of them, the third, is both compressed and encrypted. While running the app, the user can adjust the target installation and backup locations.

NOTE: The jumpstart called JumpStartGetRemoteInstallationFileBasic() mentioned above is presently only available in this demo app. In March 2006 this will be made available from the CHT Jumpstart interface on an "Installation" tab along with two others that auto enable website security and serial number authentication against a standard CHT web server.

Any questions, feel free to ask: news.cwhandy.com

Some Features Illustrated In This Application:
* ListBoxBrowseExtender Has Green Bar.
* ListBoxBrowseExtender Has Query Control.
* ListBoxBrowseExtender Has Query Builder (Extends Query Control).
* Optionally use ORDER BY In Query Control For Mult-Column Sort.
* ListBoxBrowseExtender Honours Retain-Record.
* ListBoxBrowseExtender Generates Data Queue

Any questions, feel free to ask: news.cwhandy.com

A variation of this application was used to provide "Live-Update" services for your Clarion Handy Tools tool kit before we introduced WEBLOADER and WEBUPDATER.

This demo client can easily be configured to your own purposes to provide product updates or to service a variety of file transfer requirements for which you might otherwise be inclined use less secure transfer technologies such as FTP.

Primary Templates Used:
* EmbedWindowFunctions - attaches the HNDWindow class to your app
* HandyMarkerBrowse - record reorder, record marking on an ABC browse
* HandyFileSelectorControl

The HNDLNCH.TPS file provided with this demo contains a list of reference and help documents (.HLP, .HTML and .PDF) available with a full CHT install, as well as a number of support executables such as HNDCMP.EXE the CHT compile manager. If the check mark beside any file is unchecked, this indicates that the file named, is not available at the location indicated.

These extension/control templates provide TCP/IP connectivity with a browser or with a client application. In this particular example, application functionality has been configured to act as a dynamic page server that delivers a list of downloadable files, obtained from a secure location. Downloading is not allowed only by registered individuals.

The BrowserServerInitializationControls template provides a mode switch that lets your application act as follows:

* A 100% Static Page Web Server
* A 100% Thin Client Data Server
* A Dynamic/Static Web Page Browser Server

This application is entirely template-built and contains almost no hand-embedded code.

NOTE: This server is intended as a starting point for Browser Server students building servers.

In about 30 seconds you can build procedures that, like the examples provided, launch your default email client and prepare it for sending email, and even auto send the mail without user intervention.

While HandyMailMeControl adds a HNDWindow class instance to your procedure unconditionally, the _EWF template is a child of EmbedWindowFunctions (hence, _EWF in the name) and only becomes visible when that template is already present on your application. It shares the HNDWindow class instance populated by EmbedWindowFunctions.

This application is half of a two-application set and acts as client that sends messages - up to 212 characters long - to a server application called HNDMAILSLOTSV.APP.

An MS Windows "Mailslot" provides for inter-application/inter-process messaging. Applications sharing a network domain can talk to one another and give or receive commands over a Mailslot.

The template incorporates a CHT COM MailSlot Class Wrapper called HNDMailSlotClass into your procedure. See HNDMAIOT.INC, HNDMAIOT.CLW and HNDMAIOT.TLB to study the header, code module and method interfaces respectively.

Any questions feel free to ask.

This application is half of a two-application set and acts as a server that picks up messages - up to 212 characters long - posted from the client application called HNDMAILSLOTCL.APP. An MS Windows "Mailslot" provides for inter-application/inter-process messaging. Applications sharing a network domain can talk to one another and give or receive commands over a Mailslot.

The template incorporates a CHT COM MailSlot Class Wrapper called HNDMailSlotClass into your procedure. See HNDMAIOT.INC, HNDMAIOT.CLW and HNDMAIOT.TLB to study the header, code module and method interfaces respectively.

Any questions feel free to ask.

The player is built on CHT Template HandyComMediaControl which uses the Windows Media Player COM object based in WMP.DLL.

The player is capable of playing off-line any videos which have been previously viewed to completion. On-line viewing of uncached videos begins quickly, once approximately 5 percent of the video has downloaded, and already-cached videos begin immediately since they are not downloaded again.

If you plan to adapt this application to act as a video player for your own videos, a useful, accompanying application called HNDBUILDVIDEOLIST.APP can build video index files on your CHT-based video server, of the type utilized by this application and by the HNDWindowsMediaPlayer class (HNDWMP.INC, HNDWMP,CLW, HNDWMP.TLB).

Any questions, feel free to ask: news.cwhandy.com

These are ADVANCED send procedures using higher level HNDSMTP features such as authentication, HTML email and encryption.

All procedures in this application are available as JUMP START procedures via the CHTJumpStartProceduresUtility Template. Import any of them into your application as a model from which to work forward.

Any questions, feel free to ask: news.cwhandy.com

These are BASIC send procedures using a minimum of HNDIMAIL features, designed specifically for easy understanding. More complex mail procedures are available in other demonstration applications.

All procedures in this application are available as JUMP START procedures via the CHTJumpStartProceduresUtility Template. Import any of them into your application as a model from which to work forward.

Any questions, feel free to ask: news.cwhandy.com

These are BASIC send procedures using a minimum of HNDSMTP features, designed specifically for easy understanding. More complex mail procedures are available in other demonstration applications, for example, HNDMLADSM.APP.

All procedures in this application are available as JUMP START procedures via the CHTJumpStartProceduresUtility Template. Import any of them into your application as a model from which to work forward.

Any questions, feel free to ask: news.cwhandy.com

ApplicationImagesEx keeps track of the images used in your application and controls consistency of your visual style in a format that can be configured at an installation-wide level.

EmbedWindowFunctions provides, advanced icon menus, application-in-tray, window boxes and much more.

The parent template of the above two is AACHTControlPanel, from which many aspects of application configuration are controlled.

Procedures in this application are available as JUMPSTART procedures via the CHTJumpStartProceduresUtility Template under the topic Main And Splash.

See also the CHT demo application called HNDCOLOR.APP which acts as a color, font, style configurator for the above suite of templates.

Any questions, feel free to ask: news.cwhandy.com

The class attached to your procedure by this template, once initialized gives your procedure the ability to detect all changes occuring in a nominated directory. Whenever a new file is added to this directory, or a file is changed, your procedure is sent an event called EVENT:FileChanged to signal that this has occurred. At that point, what you do as a programmer to act on that event is wide open.

This application illustrates one use of this new, directory monitoring capability. When a file is added to the designated source directory, that file is copied into a temporary, processing directory, from where it is compressed and encrypted into a CHT .HZO transport container.

The file or files meeting the filter setting provided on the application interface, eventually then, end up compressed into this .HZO container. There is also an optional switch to remove the processed source file(s) from the directory being monitored.

Any questions, visit www.cwhandy.com.

This client application serves to illustrate how to log in and then make a variety of data requests and data updates from a Clarion client application (using the HNDCLNT class) to a CHT Server configured for Client Server Mode. This application and accompanying server provide the theoretical backdrop for the CHT Client Server course.

This uses templates HandyWebClientBrowseProcedure and HandyWebClientUpdateFormProcedure, to build the web browse and web update form, respectively.

Any questions, feel free to ask: news.cwhandy.com

We've had this server - or an earlier variation of it - in active service since 2002. It has evolved since then, as have the templates and classes on which it is based. But the fundamental principles and practices in its design have remained pure ABC. If you understand Clarion, and ABC Object Oriented Principles, you can duplicate a server of this type using The Clarion Handy Tools.

CHT Servers of this type do not rely on any generic web server software like Microsoft Internet Information Server. It ties directly into the TCP/IP libraries built into the Windows NT/XP/Vista operating systems. Beyond that, all Internet listening, sending activities, data packaging, compression, encryption and so forth are written in Clarion OOP source code available as part of the fully-integrated CHT tool kit.

Principle server templates in use are: EmbedBrowserServer and BrowserServerInitializationControls, accompanied by a group of page-builder templates that are able to generate XHTML or pure Javascript Data Objects. Included with the CHT Tool Kit is a multi-function editor/scripter (HNDSCRPT.APP) which is used to design the client-side/browser side pages and forms, including CSS (Cascading Style Sheets) and JS (Javascript) Subroutines.

This server application requires a matching demonstration client called HNDMTSCL.APP. The server provides both compressed and encrypted data streams consisting of browse data, form data, report and process data based on interactive queries placed from the client side targeted at pre-determined data views (single or multi-table) provided in the server.

This application is entirely template-built and contains almost no hand-embedded code.

It illustrates how the EmbedNetDateTimeClasses template can give your procedure the ability to obtain detailed system and file date time information, for example time zone information, UTC date time information, and more.

HNDNETDATETIME.DLL is a viable .NET assembly that also works with Clarion.NET.

Any questions feel free to ask.

It illustrates how the EmbedNetDriveDataClasses template can give your procedure the ability to obtain detailed information about the drives attached to your computer, for example the hardware serial number (manufacturer assigned and unaffected by disk reformat), as opposed to the volume serial number (operating system assigned and changed by reformat).

HNDNETDRIVEDATA.DLL is a viable .NET assembly that also works with Clarion.NET.

Any questions feel free to ask.

The template provides easy to use FTP functions for uploading, downloading, deleting, listing files on an FTP server.

The template incorporates a CHT NET Wrapper called HNDNETFTPClass into your procedure. See HNDNETFTP.INC, HNDNETFTP.CLW and HNDNETFTP.TLB to study the header, code module and method interfaces respectively.

HNDNETFTP.DLL is a viable .NET assembly that also works with Clarion.NET.

Any questions feel free to ask on the CHT support forum.

The application, via the provided CHT templates and classes, provides information such as name and speed about your wireless connection(s).

CHT templates and classes with the word "NET" incorporated are based in .NET assembly DLLs which work with Clarion .NET, Clarion 6 and Clarion 7.

Any questions, feel free to ask: news.cwhandy.com

The template provides two interface controls, a string control for messages and a progress control to indicate progress through bulk zip and unzip operations. Since this is a "Control" template it operates from a window. If a silent, or invisible zip operation is required, use the ZipSilent() function provided and illustrated. Operations provided are: bulk zip with mask, bulk unzip with mask - UnZipSilent().

The template incorporates a CHT NET Zipper Wrapper called HNDNETZipClass into your procedure. See HNDNETZIPPER.INC, HNDNETZIPPER.CLW and HNDNETZIPPER.TLB to study the header, code module and method interfaces respectively.

Any questions feel free to ask on the CHT support forum.

The HNDOfficeOutlook class is introduced to the procedure via a template called EmbedHndOutlookClassFunctions. Then a second template called HandyOutlookInterfaceControls has been added to the main window to illustrate a variety of functions available.

This application is a work in progress intended for expansion as CHT Outlook templates are added and improved.

Any questions, feel free to ask: news.cwhandy.com

A CHT control template called HandyCOMOutLookControl helps you drop this control onto any application window and instantiate a Clarion-style interface to the COM IViewCtl control.

With the HndComOutlookControl template and it's underlying CHT OOP classes you can have a fully interactive MS Outlook application running in your Clarion Window, including such Outlook features as Inbox, OutBox, Sent Items, Calendar, Contacts, Journal, Notes, Tasks and Drafts.

Any questions, feel free to ask: news.cwhandy.com

The HNDOfficeOutlook class is introduced to the procedure via a template called EmbedHndOutlookClassFunctions. Then a second template called HandyOutlookInterfaceControls has been added to the main window to illustrate a variety of functions available.

This application is a work in progress intended for expansion as CHT Outlook templates are added and improved.

Any questions, feel free to ask: news.cwhandy.com

HNDPLAY.PRJ is the first of three HNDPLAY projects and easiest to understand version of the set. It finds MP3s sitting on your disk drive in a directory called \MP3\ below your exe directory and plays them consecutively. Volume is faded in programmatically at the start of each file and faded out programmatically at the end.

Any questions, feel free to ask CHT Support Forum

HNDPLAY2.PRJ is the second of three HNDPLAY projects. It extends HNDPLAY.PRJ by having the MP3's available compressed in a CHT container file. Files are extracted to your drive in advance of being played, if not already there, and are removed again when playing completes. Songs played depend on the contents of your container file.

Any questions, feel free to ask CHT Support Forum

HNDPLAY3.PRJ is the third of three HNDPLAY projects. It extends HNDPLAY2.PRJ by downloading a CHT .HZO container file from our website. Files are extracted to your drive in advance of being played, if not already there, and are removed again when playing completes. Songs played depend on the contents of your container file.

Any questions, feel free to ask CHT Support Forum

Developers can drop one or more instances of this template on any Clarion Window procedure. It's easy to build colorful popup menus in seconds. While all of the work can be done on the template interface, optional embed points are provided for developers advanced enough to embed popup menu execution code.

This application illustrates 5 instances of the template starting a variety of CHT demo applications.

With a progress bar, users can follow the progress of a lengthy operation. A progress bar may show either an approximate percentage of completion (determinate) or indicate that an operation is ongoing (indeterminate). Microsoft usability studies have shown that users are aware of response times of over one second. Consequently, you should consider operations that take two seconds or longer to complete to be lengthy and in need of progress feedback.

See HNDPRGBR.INC, HNDPRGBR..CLW and HNDPRGBR..TLB to study the header, code module and method interfaces respectively.

Any questions, feel free to ask: news.cwhandy.com

Other significant templates used in this appliction:
* HandyFileSelector - select files with advanced querying
* ListBoxBrowseExtender - list box header click column reorder, record marking and more

Other significant classes used in this appliction:
* HNDisk - advanced, low level disk functions
* HNDFileLoadBrowse - list box record marking, querying, sorting
* HNDWindow - advanced, low level window functions
* HNDAnimate - MS Windows animation control

CHT subscribers should study the header file for our HNDAVI class to get a deeper understanding of the properties and methods available.

Any questions, feel free to ask: news.cwhandy.com

HandyClarionReportWriterControl_TXR lets you configure a disk location where your .TXRs are located. The template reads and creates a POPUP menu of TXR-based reports that can be selected and printed using the window controls provided.

HandyClarionReportWriterControl_HZO lets you store your .TXRs to a CHT setup container created by HNDSETUP.APP. TXRs can be stored compressed, in any quantity. The template presents a list of TXRs in a POPUP menu from which a selection can be made using the window controls provided.

Both templates handle printing control, preview, progress, and variable file names as configured in CHT's VBLFileNames Template.

BulkSearchReplaceText() -
Searches through text and program code files of all types in the target directory to replace words, commands, phrases.

BulkFileRename() -
Adds a prefix and removes spaces and extended characters from filenames in the target directory.

Use it to create HTML/Javascript page and form scripts, Javascript Subroutines, HTML/Text email scripts and Cascading Style Sheets.

Once signed onto your server project directory this scripter will interact with your locally running server to give you real-time page previewing using live data from your server.

The Server Variables component of this application interacts with CHT page templates and web data generation templates so that web data variables are available for pop-up selection during script creation sessions.

Any questions, feel free to ask: news.cwhandy.com

Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.com
news.cwhandy.com

This specific example application enteracts with another CHT demo application called hndwindowsservicedemo.app, but an application of this sort could be made to control multiple services running on the same hardware.

Key templates installed are EmbedWindowFunctions to handle inter-application communication by posting events to the target service's window, EmbedShellFunctions to handle starting and stopping the target service and HandyServiceRemoteControlButtons_ESHF to write all the remote control code.

Any questions, feel free to ask: news.cwhandy.com

This specific example application enteracts with another CHT demo application called HNDWINDOWSSERVICEDEMO.APP, but an application of this sort could be made to control multiple services running on the other network-connected hardware.

Key templates installed are HandyCOMMailSlotControl to handle starting and stopping the target service and HandyServiceRemoteControlButtons_HCMSC to write all the remote control code.

Any questions, feel free to ask: news.cwhandy.com

A query allows you to describe the files to be containerized. Or files to be containerized may be dropped from MS Windows Explorer.

This application can be used to build standard .HZO installation and update files for transport and decontainerization by applications like CHT WEBUPDATER, and CHT DEMOLOADER to provide continuous, on-line updating of your software and data products.

Any questions, feel free to ask: news.cwhandy.com

It has no interface and should be run from the DOS prompt or called with clarion RUN() from an application button or menu.

Parameters must appear in one continous line on the application command line separated by spaces with each item surrounded by double quotes.

Parameters are as follows:
1) Application name and path
eg: "c:\clarion6\3rdparty\hnd\hncmp.exe"

2) Application description.
eg: "CHT Compile Manager"

3) Short cut file name.
eg: "CHT Compile Manager.lnk"

4) Application work path
eg: "c:\clarion6\hndapps"

5) Installation location (usually "5" for \program files\)
eg: "5"

6) Installation Icon (usually "0" for first application icon)
eg: "0"

Any questions, visit the CHT Forum.
http://support.cwhandy.ca

Use HNDSETUP.APP to build an .HZO container with the files to be installed. Then invoke it's "Code Generator Dialog" to configure your installation parameters, and to generate a file called "hndsinglesetupincludefile.clw".

Once the "Code Generator Dialog" in HNDSETUP.APP has completed its work, by generating a file called "hndsinglesetupincludefile.clw", compile this application (HNDSINGLESETUP.APP) to create the installer .EXE from the code generated by HNDSETUP.APP.

Finally, back in HNDSETUP.APP upload your installer exe and it's installation container to your website using FTP capability built into that application.

Any questions, visit CHT's support forum at:
http://support.cwhandy.ca

The application illustrates how to make file requests from a Clarion application and how to send User Custom Requests to a CHT style custom server.

The HNDSLFSV.APP illustrates two remote function calls using User Custom Requests (UCR$). The developer is encouraged to create new custom requests and to send them from this application by introducing extra custom request handling code into HNDSLFSV.APP.

Any questions, feel free to ask: news.cwhandy.com

These extension/control templates provide TCP/IP connectivity with a browser or with a Clarion client application using HNDHttp or HNDClient classes. In this particular example, application functionality has been limited to acting as a static page browser server and providing two example UCR$ (User Custom Request) procedure calls that may be called from client applications HNDHTGT.APP or HNDSLFCL.APP.

The BrowserServerInitializationControls template provides a mode switch that lets your application act as follows:

* A 100% static page server (This server uses this switch setting)
* A 100% thin client data server
* A dynamic/static page server

This application is entirely template-built and contains almost no hand-embedded code.

A CHT control template called HandyComSliderControl helps you drop this control onto any application window and instantiate the Clarion-style interface to the COM ISlider control.

Any questions, feel free to ask: news.cwhandy.com

This application and the HNDNetSMTP class, while doing some practical work, serve the primary purpose of allowing developers to explore the implications of using actual .NET DLLs in their Clarion applications. The operating system environment on which this application runs, must have at least Microsoft Framework 2 installed. Follow link: http://www.cwhandy.ca/may2007.htm#may_14_2007

The technique of using "COM Interop" to DLLs created with a .NET compiler such as C#.NET or VB.NET provide a wealth of opportunity to expand the capabilities of CHT and consequently the capabilites of Clarion 6 and Clarion 7. We'd appreciate your feedback in testing this simple application in your development environments.

Source_EmbedMAPIFunctions template
Source_EmbedZipFunctions template

The SMTP template provides an embeddable CHT class called HNDSmtp located in HNDIMAIL.INC and HNDIMAIL.CLW.

The ZIP template provides an embeddable CHT Class called HNDComZipClass located in HNDZIPPR.INC and HNDZIPPR.CLW.

If you want to learn to hand code with these two classes, this application is a perfect learning platform. The procedures provided may also be imported directly into your apps to provide pre-built functionality.

Source_EmbedSMTPFunctions template
Source_EmbedZipFunctions template

The SMTP template provides an embeddable CHT class called HNDSmtp located in HNDSMTP.INC and HNDSMTP.CLW.

The ZIP template provides an embeddable CHT Class called HNDComZipClass located in HNDZIPPR.INC and HNDZIPPR.CLW.

If you want to learn to hand code with these two classes, this application is a perfect learning platform. The procedures provided may also be imported directly into your apps to provide pre-built functionality.

It drops a single "Spell Check" button onto your window to trigger spell-checking in entry and text controls populated on the procedure window. Checking can be triggered for the entire window using the button provided or individual controls can be checked using a configurable hot key.

Further, individual words may be checked by selecting the word and using a configurable hot key. Initially we are providing, on request, lexicons for the following languages: English, Afrikaans, Croatian, French, German, Greek, Italian, Netherlands, Portugese, Russian, Spanish, Swedish, Ukranian.

Since these lexicons are derived from open-source word lists, we will ask developers seeking non-English dictionaries to help us develop a common-words list for their chosen language. A common-words list is a set of the top 25-50 most commonly used words. In English, for example, these are words like "the", "and", "to", and so forth.

As of CHT build 112A1.01 CHT spell checking has been taken out of BETA and placed into RELEASE status. Four dictionaries are presently available: English, French, Afrikaans, and Portugese. Aside from English, we chose to release these languages first because developers contacted us and specifically encouraged us to do so.

If you speak and work in any of the above listed, but not-yet-implemented langauges, feel free to contact us and encourage us to give priority to your language in an upcoming build.

Any questions, feel free to ask:
www.cwhandy.ca
news.cwhandy.ca

It drops a local spell check template called LocalIncludeSpellingCheck onto your window to trigger spell-checking in entry and text controls populated on the procedure window. Checking can be triggered for the entire window using CtrlF7 (reconfigurable) or individual controls can be checked using another configurable hot key.

Further, individual words may be checked by selecting the word and using a configurable hot key. Initially we are providing, on request, lexicons for the following languages: English, Afrikaans, Croatian, French, German, Greek, Italian, Netherlands, Portugese, Russian, Spanish, Swedish, Ukranian.

Since these lexicons are derived from open-source word lists, we will ask developers seeking non-English dictionaries to help us develop a common-words list for their chosen language. A common-words list is a set of the top 25-50 most commonly used words. In English, for example, these are words like "the", "and", "to", and so forth.

Four dictionaries are presently available: English, French, Afrikaans, and Portugese. Aside from English, we chose to release these languages first because developers contacted us and specifically encouraged us to do so.

If you speak and work in any of the above listed, but not-yet-implemented langauges, feel free to contact us and encourage us to give priority to your language in an upcoming build.

Any questions, feel free to ask:
www.cwhandy.ca
news.cwhandy.ca

The EmbedHNDSplitter extension template is applied to the procedure first. This is the parent of the two related control templates. Then HandySplitBarVertical and HandySplitBarHorizontal can be applied as required by the developer.

This example has applied the ABC resizer to allow window and control resize. The EmbedHNDSplitter template allows for optional interaction with ABC resizer. The default setting is to disable this ABC resizer interaction. When ABC resizer is enabled, it's up to the developer to apply that template to the procedure and configure it to his liking.

It illustrates these concepts:
*** A CHT Query Builder implementation returning SQL in the foreground.
*** A hand built SQL query control using an ABC reset field and a standard entry control
*** Hiding/unhiding columns programmatically
*** Hidden columns are hidden also in CHT Query Builder

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** SQLFillQueueFromView() example of filling browse queue.
*** HINI.BINIO.DumpQueue('queuename.txt') example.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** A CHT Query Builder implementation returning SQL in the foreground.
*** An hand-built SQL query control using an ABC Reset Field and a standard entry control.
*** Hiding/unhiding columns programmatically
*** Hidden columns are hidden also in CHT Query Builder

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** A CHT ExplorerBrowse Template
*** A CHT ExplorerBrowseQueryBuilder Template

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** A CHT HandyMarkerBrowse Template
*** A CHT HandyMarkerBrowseQueryBuilder Template

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** A CHT HandyQueryProcessLimiter Template
*** A CHT HandyQueryProcessLimiterQBControl Template

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** A CHT HandyQueryReportLimiter Template
*** A CHT HandyQueryReportLimiterQBControl Template

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** Display data only when the filtering locator has an entry.
*** Locator drill-down "breadcrumb" trail.
*** Display either CHT query language or SQL.
*** Execute Locator with tab or with GO button.
*** SQLSelect example of filling browse queue with user SELECT.
*** EmbedViewEx filling browse queue with in-line process.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** Display data only when the filtering locator has an entry.
*** Locator drill-down "breadcrumb" trail.
*** Display either CHT query language or SQL.
*** Execute Locator with tab or with GO button.
*** SQLSelect example of filling browse queue with user SELECT.
*** EmbedViewEx filling browse queue with in-line process.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

It illustrates these concepts:
*** SQLSelectQ example of filling browse queue with user SELECT.
*** EmbedViewEx filling a browse queue using an in-line process.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.

Start tracing by configuring the specific driver(s) used by your SQL application followed by a click on the "Minimize" button . Once this application is started, then start your SQL application.

Navigate in your SQL application to the specific area to be tested and bring HNDSQLTRACE.APP back up using the windows task bar icon menu provided.

When HNDSQLTRACE.APP re-appears all SQL statements executed to that point are displayed in reverse chronological order, with newest statements at the top. From this point forward, to trace specific actions, click the "Clear" button and interact briefly with your SQL application. Click the "Read Next" button to view the most recent SQL activity raised by your application. Repeat as necessary.

Any questions, feel free to ask.
Gus M. Creces
The Clarion Handy Tools Page
http://news.cwhandy.ca/LOG$

HANDYSOURCEPROCEDURE_TS is a source procedure template like HANDYSOURCEPROCEDURE. The _TS version presents an opportunity to attach a full table schematic (with joins) to your source procedure. This template will act as a base template for a number of plug-in templates the first of which is HANDYINLINEPROCESS_HSP.

The app illustrates a window containing an ordinary Clarion List box using a queue which is now being generated by LISTBOXBROWSEEXTENDER. When a query executes, the queue is passed to one of these HANDYINLINEPROCESS_HSP procedures where records matching the query are added to the queue. The queue then displays data on your window as if it were a Clarion browse.

Various other "Packaging" dialogs will be added to the HANDYINLINEPROCESS_HSP template: TO XML, TO HTML, TO PDF, TO EXCEL, TO TEXT, TO DATA STREAM, TO JAVASCRIPT DATA OBJECTS, TO REPORT - WMF, TO GRAPH, and TO ANYTHING ELSE you tell us you need.

Any questions, feel free to ask: news.cwhandy.com

The application runs as a service to start user-designated applications (like servers) listed in the application's configuration file HNDSTARTERSERVICE_A.INI. Up to 100 applications may be started by this service. A delay time setting allows sufficient time after a re-boot for
the machine to settle down before your applications are started, each about 30 seconds apart.

To install the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /IS
To start the service - once installed - from the DOS prompt type:
HNDBACKUPSERVICE_A /SS
To stop the service from the DOS prompt type:
HNDBACKUPSERVICE_A /STOP
To remove the service, from the DOS prompt type:
HNDBACKUPSERVICE_A /RS

These extension/control templates provide TCP/IP connectivity with a browser or client application. In this particular example, application functionality has been limited to acting as an HTTP file transfer server. It requires a file transfer client to interact with it. Two separate demo client applications are provided to subscribers: HNDFLCLN.APP and HNDLIVUP.APP. Also, HNDHTTPZIPNPOST.APP is able to upload to this server when set for CHT server access.

The server maintains complete control of which files and directories are visible to the client. File transfers are optionally compressed and/or encrypted at the request of the client application.

This application is entirely template-built and contains almost no hand-embedded code.

For developers working in a team, especially teams with remote members, it's useful for members to know which versions of the applications for which they are responsible have been centrally compiled for QA. With each re-build, using CHT Compile Manager, a set of HTML pages is generated into this server's "run" directory, detailing the applications with a variety of information from version number, to procedure docs, to templates in use.

Note that the base page required by this server is docindex.html. CHT compile manager generates a matching index page with this name.

This application is entirely template-built and contains almost no hand-embedded code.

The JumpStartSemiSilentHZOCompression(). function takes the following parameters:
xSrc - A root source directory for files to be compressed
xTgt - A target directory and file name of an hzo container
xQry - A CHT File Query to describe the files to be compressed
xPwd - A password to be used in data-encrypting the files
xSubs - True or false to indicate search subdirectories of the root source
xWinHndl - Window handle of parent window
*xProgress - Reference to progress variable local to parent window
The function returns the number of files compressed if successful and zero if it fails.

Any questions, feel free to ask: news.cwhandy.com

The JumpStartSemiSilentHZODeCompression(). function takes the following parameters:
xSrcFile   Name of the .HZO container to be processed
xTgt   A target directory into which the .HZO is decontainerized
xQry   A CHT File Query to describe the files to be decompressed
xPwd   A password to be used in data-decrypting the files
xSubs   True or false to include subdirectories of the root source
xWinHndl - Window handle of parent window
xProgress - Reference to progress variable local to parent window

The function returns the number of files decompressed if successful and zero if it fails.

Any questions, feel free to ask: news.cwhandy.com

The JumpStartSilentHZOCompression(). function takes the following parameters:
xSrc   A root source directory for files to be compressed
xTgt   A target directory and file name of an hzo container
xQry   A CHT File Query to describe the files to be compressed
xPwd   A password to be used in data-encrypting the files
xSubs   True or false to indicate search subdirectories of the root source

The function returns the number of files compressed if successful and zero if it fails.

Any questions, feel free to ask: news.cwhandy.com

The JumpStartSilentHZODeCompression(). function takes the following parameters:
xSrcFile   The .HZO file to be decontainerized
xTgt   A target directory into which the .HZO files are decompressed
xQuery   A CHT File Query to describe the files to be decompressed
xPwd   A password to be used in data-decrypting the files
xSubs   True or false to nclude subdirectories of the root source

The function returns the number of files decompressed if successful and zero if it fails.

Any questions, feel free to ask: news.cwhandy.com

Categories of functionality available are as follows:
Manipulating/Finding Files and Paths, Windows SHELL, Email Address Validity Check, Case Ajdustment, Disassembling Character Delimited Strings, Directories, Drives, Windows GUID, Determining Hash Values, Determing Data Type, Windows Environment, Reading/Writing Text Files, Windows System Manipulation, HTML HEX Colors, HTML Escape Characters, Windows Error Log, Runtime Error Viewing/Tracing, Memory Files, Manipulating/Extracting Strings

The application also generates an ordered HTML version of this information for use in our website. Template listings may be generated in template-type order with breaks on type, or in template name order.

Key templates illustrated: ExplorerBrowse, QueryParsingFilterControl, EmbedDiskFunctions, EmbedFilterFunctions, HandySourceProcedure and EmbedStandardWebPageHeader.

Any questions, feel free to ask: http://news.cwhandy.com

To test this, run the PULL procedure first. This pulls batches of icon files from an FTP site established for this test. After that, run the PUSH procedure. It uploads the same set of files just downloaded and deletes them if successfully uploaded. Then, once you're familiar with its operation, simply modify the application INI with your own parameters. The application illustrates some aspects of use for the following templates and classes:

FTP Classes And Templates:
* HNDInetFTP - handles all aspects of FTP communications
* HNDIDial - handles all aspects of connectivity, network or dialup
* EmbedInternetFTP (parent template),
* HandyFTPInitializationControls - gather logon and user information
* HandyFTPLocalFilesControls - gather upload file information
* HandyFTPLocalFilesULControls - upload files control panel
* HandyFTPRemoteFilesControls - gather download file information
* HandyFTPRemoteFilesDLControls - download files control panel

This application shows you:
* How to configure your SMTP/POP settings on any machine
* How to download mail headers into a queue and display them
* How to delete unwanted mail and spam without ever downloading it
* How to download wanted mail into standard .EML text files
* How to download mail into a CHT .HML TopSpeed file

Any questions, feel free to ask: news.cwhandy.ca

The player is built on CHT Template HandyComMediaControl which uses the Windows Media Player COM object based in WMP.DLL.

The player is capable of playing off-line any videos which have been previously viewed to completion. On-line viewing of uncached videos begins quickly, once approximately 5 percent of the video has downloaded, and already-cached videos begin immediately since they are not downloaded again.

If you plan to adapt this application to act as a video player for your own videos, a useful, accompanying application called HNDBUILDVIDEOLIST.APP can build video index files on your CHT-based video server, of the type utilized by this application and by the HNDWindowsMediaPlayer class (HNDWMP.INC, HNDWMP,CLW, HNDWMP.TLB).

In about 30 seconds you can build procedures that, like the examples provided, launch your default browser and visit the URL of your choice.

While HandyVisitMeControl adds a HNDWindow class instance to your procedure unconditionally, the _EWF template is a child of EmbedWindowFunctions (hence, _EWF in the name) and only becomes visible when that template is already present on your application. It shares the HNDWindow class instance populated by EmbedWindowFunctions.

This application may be used to send images and media files such as .SWF to our forum server in the event you want to include one or more screen shots or captures with your forum messages and questions.

Images are placed in the /images/ directory and image links in your messages are provided on the clipboard ready to be pasted into your forum message. Media files are placed in the forum /docs/ directory and again a link is provided to allow readers to view the file in a separate browser window.

Any questions, feel free to ask: support.cwhandy.com

Windows Script Host provides a wide variety of low-level operating system configuration functions normally enabled in WScript, JScript and VBScript. Microsoft describes Windows Script Host as follows: "Windows Script Host (WSH), a feature of the Microsoft<174> Windows<174> 2000/XP family of operating systems, is a powerful multi-language scripting environment ideal for automating system administration tasks.

Scripts running in the WSH environment can leverage the power of WSH objects and other COM-based technologies that support Automation, such as Windows Management Instrumentation (WMI) and Active Directory Service Interfaces (ADSI), to manage the Windows subsystems that are central to many system administration tasks."

This template and its underlying wrapper class, HNDScriptHostClass based in modules HNDWSHOM.INC /HNDWSHOM.CLW /HNDWSHOM.TLB provide you the equivalent of running windows administration scripts from inside your Clarion application, using Clarion syntax rather than writing WScript, JScript or VBScript.

Any questions, feel free to ask: news.cwhandy.com

To install this service application, at the DOS prompt type:
HNDWINDOWSSERVICEDEMO /IS or /INSTALL or /ISQ (quiet)

To start the service once installed, at the DOS prompt type:
HNDWINDOWSSERVICEDEMO /SS or /START

To stop the service once installed, at the DOS prompt type:
HNDWINDOWSSERVICEDEMO /SP or /STOP

To remove the service once installed, at the DOS prompt type:
HNDWINDOWSERVICEDEMO /RS or /REMOVE or /RSQ (quiet)

See HNDSERVICEUP.APP and HNDSERVICEUPREMOTE.APP for examples of how to control and configure this service remotely from another application.

This application starts with it's window minimized and hidden. It's application icon appears on the Windows Task Bar from which it can be commanded. By unchecking the "Application In Tray" switch on the EmbedWindowFunctions template in the main procedure, this application can be made to run completely hidden, while still being configured remotely from HNDSERVICEUPREMOTE.APP or HNDSERVICEUP.APP.

Any questions, feel free to ask: news.cwhandy.com

CHT's HNDShell Class provides a wide variety of low-level operating system configuration functions normally available in WScript, JScript and VBScript.

This template and its underlying wrapper class, HNDShell based in modules HNDSHELL.INC /HNDSHELL.CLW /HNDSHELL.TLB provide you the equivalent of running certain windows administration scripts from inside your Clarion application, using Clarion syntax rather than writing WScript, JScript or VBScript.

Any questions, feel free to ask: news.cwhandy.com

The HNDMSWORD class is introduced to the procedure via a template called EmbedWordFunctions.

This application, in an of itself uses a window with no controls that minimizes itself and drops an icon on your tool bar from where several command menu items illustrate programmatic control over MS Word.

Any questions, feel free to ask: news.cwhandy.com

The HNDOfficeWord class is introduced to the procedure via a template called EmbedHndWordClassFunctions. Then a second template called HandyWordInterfaceControls has been added to the main window to illustrate a variety of functions available.

This application is a work in progress intended for expansion as CHT Word templates are added and improved.

Any questions, feel free to ask: news.cwhandy.com

Any questions, feel free to ask: news.cwhandy.com

The proprietary CHT compression library is used by some of the functions in HNDDisk for file compression and decompression. The compression library is run-time loaded, so that your app will run whether this DLL library is present or not.

An application-global template called IncludeCompressionLibrary is available for you to attach to your application if you plan on using CHT compression. It will remind you in the standard ship (.SHP) list to include HNDZLIBX.DLL. If your application uses the HNDDISK class but does not call any of the compression methods, it's not necessary to include the compression library with your final application.

During the "Check Installation" phase it compares a user's CHT files against CRC values available in the installation index. Missing, out-of-date and changed files are marked accordingly in the index.

In the "Tune Installation" pass, the results of the "Check Installation" phase are used to install or re-install missing and out of date files from CHT's installation containers. Files are decompressed and placed in the correct target directory and the index is updated.

Any questions, feel free to ask: news.cwhandy.com

The application can be pre-configured to back up a particular directory using a file mask and/or a CHT Query that describes the files to be backed up, resulting in a standard zip file that can include source subdirectories right inside the zip.

Once configured, your application can build a backup with one button click and with a second button click, send it to your Gmail account. Up to nine separate, unique configurations are retained for instant re-use.

Any questions, feel free to ask.

The application can be pre-configured to back up a particular directory using a file mask and/or a CHT Query that describes the files to be backed up, resulting in a standard zip file that can include source subdirectories right inside the zip.

An SMTP configuration dialog lets you preconfigure a target SMTP servers to accept your zip file.

Once configured, your application can build a backup with one button click and send it to one or more recipients with a second click. Up to nine separate, unique configurations are retained for instant re-use.

Any questions, feel free to ask.

The application can be pre-configured to back up a particular directory using a file mask and/or a CHT Query that describes the files to be backed up, resulting in a standard zip file that can include source subdirectories right inside the zip.

An FTP configuration dialog lets you preconfigure one or more target FTP servers and web directories to accept your zip file.

Once configured, your application can build a backup with one button click and send it to an FTP server with a second click. Up to nine separate, unique configurations are retained for instant re-use.

Any questions, feel free to ask.

The application can be pre-configured to back up a particular directory using a file mask that describes the files to be backed up, resulting in a standard zip file that can include source subdirectories right inside the zip.

An HTTP configuration dialog lets you preconfigure one or more target web servers (IIS or Apache) and web subdirectories to accept your zip file.

Once configured, your application can build a backup with one button click and PUT it to a web server with a second click.

Any questions, feel free to ask.