GENERATED: JUL 10,2017 - 11:14PM
ExplorerBrowse SQL Joins Demo [V10.17.05.0177]

Previous Page
This application is designed to illustrate cascading joins on a CHT Explorerbrowse. It shows how to configure up to 4 browses (1 parent and 3 children) which must each reset when the parent is reset but which then must also reset the each of the child browses below them in a top to bottom cascade.

TOPMOST (PARENT) resets all child browses
LEVEL 1 CHILD resets LEVEL 2 and LEVEL 3 CHILD
LEVEL 2 CHILD Resets LEVEL 3 CHILD

This application may be combined with HNDSQLTRACE to see the SQL being triggered as browses are reset through navigation, query, and order change. CHT Explorerbrowse optimizes and reduces the counter-productive SQL "Chatter" that normally issues from ABC Browse Class during SQL resets.


Cheers,
Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.ca (CHT Website)
news.cwhandy.ca (CHT Forum)

 
PROCEDURE (1):
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


 
PROCEDURE (2):
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 (3):
SQLFilter_ExplorerBrowse (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) HBrwC1 HNDBrowse HND 431 HNDBROWS.INC
(0007) HBrwC2 HNDBrowse HND 431 HNDBROWS.INC
(0008) HBrwC3 HNDBrowse HND 431 HNDBROWS.INC
(0009) HBrwP HNDBrowse HND 431 HNDBROWS.INC
(0010) HQry6 HNDBrwFilter HND 320 HNDBRWFL.INC
(0011) HSizes16 HNDSizes HND 23 HNDSIZES.INC
(0012) HSizes17 HNDSizes HND 23 HNDSIZES.INC
(0013) HSizes19 HNDSizes HND 23 HNDSIZES.INC
(0014) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0015) HWin11 HNDWindow HND 214 HNDWINDO.INC
(0016) BRW15::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0017) BRW18::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0018) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0019) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0020) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0021) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0022) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0023) BRW7::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0024) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0025) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(25) Class Instances Found In SQLFilter_ExplorerBrowse


 
PROCEDURE (4):
ABCUpdateForm (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 ABCUpdateForm


 
PROCEDURE (5):
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


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

chtlogo001.gif Classes By Procedure In HNDEXPLORERSQLJOINTEST.APP