GENERATED: JUL 11,2017 - 12:39AM
Mixed Browse Extensions SQL Joins Demo [V10.17.05.0157]

Previous Page
This application illustrates a mixed browse extension, SQL Join set of browses consisting of HandyMarkerBrowses (Parent, Child1 and Child3) and ExplorerBrowse (Child2).

This app was developed as a test application to study ABC Browse Class reset behaviour by tracing with HandySQLTrace. It was used in revisions to CHT Browse Classes and templates made late May 2012.

The purpose of those revisions was to eliminate double and triple SQL requests sent from the ABC Browse classes whenever the browse was reset by an order change or a filter change.

It is the nature of templates of one type to generate code together in a given embed point (say priority 9500) in the order that the templates are populated on the window. This rule of thumb does not hold when populating two templates with different types into the same embed priority point. One template type will generate as a group, then the other, regardless of the order in which they're populated.

When creating a JOIN SET with mixed browse extensions such as in this application, CHT had to devise a way to get the templates to populate in a consistent order that matched the developer's design for browse filling order. A JOINed set of browses must always fill in the order PARENT, CHILD1, CHILD2, CHILD3.

If the templates generate into the same embed point in the wrong order (due to template types having been mixed together) the firing order of browses can become jumbled and events can collide such that browses fill in the wrong order and SQL "Chatter' results.

Our latest implementation of HandyMarkerBrowse and ExplorerBrowse extensions has overcome this native template-generation-order behaviour (where order matters) by generating into named, hidden, embed points based on each template's position in the JOIN SET heirarchy, regardless of the template type, allowing mixed template types in a given JOIN SET.

This application in conjunction with HNDSQLTRACE.EXE can be used to illustrate just how much CHT's latest Browse Extension templates can improve the speed and efficiency of your SQL browses.

Cheers...
Gus M. Creces
The Clarion Handy Tools Page



 
PROCEDURE (1):
RegisterODBC (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) HDisk HNDDisk HND 369 HNDDISK.INC
(0002) HReg HNDRegistry HND 310 HNDREG.INC
(2) Class Instances Found In RegisterODBC


 
PROCEDURE (2):
HMBandEBWithMultipleQueryControls (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRWC1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRWC2 BrowseClass ABC 85 ABBROWSE.INC
(0003) BRWC3 BrowseClass ABC 85 ABBROWSE.INC
(0004) BRWP BrowseClass ABC 85 ABBROWSE.INC
(0005) BRW1::EIPManager BrowseEIPManager ABC 46 ABBROWSE.INC
(0006) HExplC2 HNDBrowse HND 431 HNDBROWS.INC
(0007) HQry16 HNDBrwFilter HND 320 HNDBRWFL.INC
(0008) HMrkBrwC1 HNDMarkerBrowse HND 476 HNDMRKBR.INC
(0009) HMrkBrwC3 HNDMarkerBrowse HND 476 HNDMRKBR.INC
(0010) HMrkBrwP HNDMarkerBrowse HND 476 HNDMRKBR.INC
(0011) HSizes8 HNDSizes HND 23 HNDSIZES.INC
(0012) HWin11 HNDWindow HND 214 HNDWINDO.INC
(0013) BRW13::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0014) BRW14::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0015) BRW19::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0016) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0017) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0018) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0019) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0020) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0021) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0022) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(22) Class Instances Found In HMBandEBWithMultipleQueryControls


 
PROCEDURE (3):
MainEntryPoint (Procedure Template: Frame)
Count Instance Class Type Methods Header File
(0001) HDisk HNDDisk HND 369 HNDDISK.INC
(0002) HReg HNDRegistry HND 310 HNDREG.INC
(0003) HWin HNDWindow HND 214 HNDWINDO.INC
(0004) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0005) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(5) Class Instances Found In MainEntryPoint


 
PROCEDURE (4):
CompanyUpdateForm (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) HWin10 HNDWindow HND 214 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ToolbarForm ToolbarUpdateClass ABC 4 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(4) Class Instances Found In CompanyUpdateForm


 
PROCEDURE (5):
JumpStartSplashCHTBlue (Procedure Template: Splash)
Count Instance Class Type Methods Header File
(0001) HTellMe HNDWindow HND 214 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(3) Class Instances Found In JumpStartSplashCHTBlue


Copyright © 1996-2017
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Classes By Procedure In HNDMIXEDBROWSESQLJOINTEST.APP