The CHT Blogger

Thanks for your interest in The Clarion Handy Tools, an awesome collection of productivity enhancements for Clarion developers. These tools consist of an ever-expanding set of Clarion Templates and OOP Classes that extend or complement the normal functionality of the Clarion Application Development System from SoftVelocity.

Monday, October 6, 2008

New Update Available 12C1.03

We've posted a new build update numbered, 12C1.03, to Webupdater today, completing the necessary changes by approx 5:30 EST (October 6, 2008). This has been up since last night, but I made several incremental changes to it during the day today. If you picked it up before reading this notice I suggest you re-run Webupdater in order to get the latest iteration of 12C1.03.

Here are some of the changes:

New Template HandyFileViewBuilder


There's a new template called HANDYFILEVIEWBUILDER. This is similar to HandyFileQUEUEBuilder with which you've been able to build a QUEUE from a table schematic created on the template. In the case of HandyFileVIEWBuilder, you're now able to build a VIEW from a table schematic created on the template. These two templates have Import/Export capability so that configurations created on one either one of them can be exported, to be imported by the other.

New Base Class Function SQLFillQueueFromView()


You're able to build an SQL browse completely independent of ABC by using LISTBOXBROWSEXTENDER to create and manage a queue and list box. Combine this with HANDYFILEVIEWBUILDER to build a matching VIEW. And to these two templates, add a new a CHT base class function available to the ListBoxBrowseExtender, called SQLFillQueueFromView() to fill the list box queue. This same base class function is available to ExplorerBrowse, HandymarkerBrowse, LocatorOverRideControl as well as all ABC processes and reports where one of our filtering templates has been placed.

New Base Class Function DumpQueue()


In the globally instatiated class HNDINI, populated by our INIFILE template, is a new function called DUMPQUEUE(). If you're trying to debug a queue-building function, use this function to dump the contents of any Queue to a text file.

New Demo Application HNDSQL10.APP


The new HNDSQL10.APP demo illustrates SQLFillQueueFromView() by filling a standard ABC Browse queue using the Queue And View already generated by the ABC template. It also illustrates the new DumpQueue() function mentioned above. By examining the application you should be able to understand what's going on.

Improvements to EmbedViewEx Template


EmbedViewEx has been updated to solve a problem with the template selecting the wrong primary file key when there's a complex view inserted and view scanning is enabled. We've also added the ability to export/import view field descriptions compatible with the above templates HandyFileQueueBuilder and HandyFileViewBuilder. Further, the template is now a MULTI, which means it can be populated multiple times on the same procedure. You can see EmbedViewEx in action on several of our newer demo applications HNDSQL7.APP and HNDSQL8.APP, for instance.

In both these demos we're using it to fill the browse queue. But EmbedViewEx can be used anywhere you might normally call a process procedure. The only caveat I'd give you in using this - because it runs in a tight loop and not on a timer - is that the view scan you're performing should be fast enough not to hang your application for more than a second or two. Think of it as a general-purpose, lightweight Clarion process, that plugs right into your procedure. View scanning can be triggered from any control that you drop on your window. Multiple view scans (applying different filters and orders) can be performed on the same view, and each of these can take some unique action on the view tables and fields being scanned. Works with SQL or ISAM.

Portuguese Dictionary Replaced And Tested


Thanks to Nelson De Carvalho for working with me to develop a new Portuguese Dictionary with the correct accentuation. The Portuguese dictionary now works correctly. A small change in the HNDSPELL class was made in addition to replacing the previous version of the HNDPORTUGUESE.DIC file.

Bug Fixes


Any bug fixes reported in the last couple of months relating to 12C1.00, 12C1.01 and 121.03 are included here as well.

• One that comes to mind is a browse reset issue reported by Robert Barton. Search on Robert's name in the CHT support forum news.cwhandy.ca to get the details of his report. He sent a test app, and a data table to help me isolate the problem which I've fixed.

• Didier, I've fixed the two issues you reported with HNDFSYNC.APP (hidden icons appearing) and HNDMTSCL.APP (losing the browse filter). I have not yet incorporated the code signing feature you asked for but I hope to incorporate that for an early version of 12D1.xx. The RowMoveButtons problem you reported has also been fixed.

• Piotr Heidak reported a problem with the template-initiated opening query on ExplorerBrowse. That's been fixed and Piotr has confirmed it works.

That's it for now.
Cheers...
Gus Creces
The Clarion Handy Tools Page
Visit Website
Message Posted From CHT Support Forum Client [V6.01.00]

No comments: