GENERATED: MAY 4,2023 - 8:39AM
SQL BROWSES EXPB_QRY [V10.23.04. 27.03]

Previous Page

This is a CHT demo built with CHT templates and is roughly based on an SV demo application called SCHOOL.APP. It experiments specifically with the School-Classes table located in HNDSCHOOL.SQLITE. The SQLite Data tables are imported from the original TOPSPEED files provided with SV's SCHOOL.APP.

It uses the SQLite driver, the ABC browse template, CHT's EXPB browse extension, set to UseSQL=True and CHT's QPFC query template.

To analyse the allocation of templates in this application, open the application in the Clarion IDE and navigate to Global Extensions, select AACHTControlPanel and click on the menu item "Templates By Proc". This sequence of actions triggers an HTML document to display which enumerates and names all templates used in the application by procedure.

We chose to apply, as always, our "minimalist" screen design which avoids unnecessary use of tab controls, and shuns MDI child windows. Control buttons are for the most part kept to the toolbar and when placed on a window are always above the edit fields or list box.

CHT TEMPLATES LEGEND:
EXPB = ExplorerBrowse
QPFC = QueryParsingFilterControl

 
PROCEDURE (1):
EXAMPLE_3_ABC_PLUS_EXPB_PLUS_QPFC (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) HBrw4 HNDBrowse HND 432 HNDBROWS.INC
(0004) HQry6 HNDBrwFilter HND 321 HNDBRWFL.INC
(0005) HSizes4 HNDSizes HND 23 HNDSIZES.INC
(0006) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin HNDWindow HND 206 HNDWINDO.INC
(0008) BRW1::Sort0:StepClass StepClass ABC 6 ABBROWSE.INC
(0009) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0010) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0011) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0014) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0015) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(15) Class Instances Found In EXAMPLE_3_ABC_PLUS_EXPB_PLUS_QPFC


 
PROCEDURE (2):
JumpStartSplash07 (Procedure Template: Splash)
Count Instance Class Type Methods Header File
(0001) HTellMe HNDWindow HND 206 HNDWINDO.INC
(0002) HWin HNDWindow HND 206 HNDWINDO.INC
(0003) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(4) Class Instances Found In JumpStartSplash07


 
PROCEDURE (3):
EXAMPLE_6_ABC_PLUS_EXPB_PLUS_LCEX (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) HBrw4 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes4 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin HNDWindow HND 206 HNDWINDO.INC
(0007) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0008) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0009) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort0:StepClass StepLongClass ABC 6 ABBROWSE.INC
(0013) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0014) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(14) Class Instances Found In EXAMPLE_6_ABC_PLUS_EXPB_PLUS_LCEX


 
PROCEDURE (4):
EXAMPLE_4_ABC_PLUS_EXPB_PLUS_OCQC (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) HBrw4 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes4 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin HNDWindow HND 206 HNDWINDO.INC
(0007) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0008) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0009) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort0:StepClass StepLongClass ABC 6 ABBROWSE.INC
(0013) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0014) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(14) Class Instances Found In EXAMPLE_4_ABC_PLUS_EXPB_PLUS_OCQC


 
PROCEDURE (5):
EXAMPLE_5_ABC_PLUS_EXPB_QBC (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) HBrw4 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes4 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin HNDWindow HND 206 HNDWINDO.INC
(0007) BRW1::Sort0:StepClass StepClass ABC 6 ABBROWSE.INC
(0008) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0009) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0010) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0014) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(14) Class Instances Found In EXAMPLE_5_ABC_PLUS_EXPB_QBC


 
PROCEDURE (6):
SelectTeachers (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) MARK HNDMarkerBrowse HND 480 HNDMRKBR.INC
(0003) HWin HNDWindow HND 206 HNDWINDO.INC
(0004) BRW1::Sort0:StepClass StepClass ABC 6 ABBROWSE.INC
(0005) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0006) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0007) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0008) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0009) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(9) Class Instances Found In SelectTeachers


 
PROCEDURE (7):
EXAMPLE_2_ABC_PLUS_EXPB (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) HBrw4 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes4 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin HNDWindow HND 206 HNDWINDO.INC
(0007) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0008) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0009) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort0:StepClass StepLongClass ABC 6 ABBROWSE.INC
(0013) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0014) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(14) Class Instances Found In EXAMPLE_2_ABC_PLUS_EXPB


 
PROCEDURE (8):
Main (Procedure Template: Frame)
Count Instance Class Type Methods Header File
(0001) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0002) HWin HNDWindow HND 206 HNDWINDO.INC
(0003) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(4) Class Instances Found In Main


 
PROCEDURE (9):
SelectCourses (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) MARK HNDMarkerBrowse HND 480 HNDMRKBR.INC
(0003) HWin HNDWindow HND 206 HNDWINDO.INC
(0004) BRW1::Sort0:StepClass StepClass ABC 6 ABBROWSE.INC
(0005) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0006) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0007) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(7) Class Instances Found In SelectCourses


 
PROCEDURE (10):
EXAMPLE_1_ABC_ALONE (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 47 ABBROWSE.INC
(0003) Handles9 HNDSizes HND 23 HNDSIZES.INC
(0004) HWin HNDWindow HND 206 HNDWINDO.INC
(0005) BRW1::Sort1:StepClass StepClass ABC 6 ABBROWSE.INC
(0006) BRW1::Sort2:StepClass StepClass ABC 6 ABBROWSE.INC
(0007) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0008) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort0:StepClass StepLongClass ABC 6 ABBROWSE.INC
(0011) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0012) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(12) Class Instances Found In EXAMPLE_1_ABC_ALONE


 
PROCEDURE (11):
UpdateClassesTable (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) HWin HNDWindow HND 206 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 40 ABWINDOW.INC
(3) Class Instances Found In UpdateClassesTable


Copyright © 1996-2023
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Classes By Procedure