This is an CHT demo actively re-built with CHT templates on ABC demo application SCHOOL.APP; hence the name HNDSCHOOL.APP. Its purpose is to study the use of the SQLite driver with CHT browses, and query templates set to UseSQL=True. We chose to "CHT-ify" this application specifically because it uses several SQLite data tables located in a repository file called SCHOOL.SQLITE. A second purpose is, of course, to provide some visual and functional contast between a raw, wizard-produced, really UGLY and semi-functional, ABC application and ABC applications extended, enhanced and functionalized by a variety of CHT templates. 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. This application applies, for the most part, CHT's browse extension template HandyMarkerBrowse (HMB); hence comes the name of the application. However, one procedure utilizes ListBoxBrowseExtender (LBX) which illustrates that an underlying ABC browse is no longer necessary to build fantastic Clarion browses. LBX browses are the bright future of data browsing with Clarion, ABC browses are the clunky past. |
PROCEDURE (1): CreateDB (Procedure Template: Source) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0) Class Instances Found In CreateDB | |||||
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): 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 (4): BrowseEnrollmentCLARIONVIEW (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) | MARK | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles8 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0007) | BRW1::Sort1:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0008) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0009) | BRW1::Sort1:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0010) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In BrowseEnrollmentCLARIONVIEW | |||||
PROCEDURE (5): SelectMajors (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | HMrkBrw4 | 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 SelectMajors | |||||
PROCEDURE (6): BrowseClasses (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) | HMrkBrw6 | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles9 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.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) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0013) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(13) Class Instances Found In BrowseClasses | |||||
PROCEDURE (7): BrowseCourses (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) | HMrkBrw6 | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles7 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0007) | BRW1::Sort0: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 BrowseCourses | |||||
PROCEDURE (8): UpdateCourses (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | Handles9 | 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 UpdateCourses | |||||
PROCEDURE (9): SelectClasses (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | HMrkBrw3 | 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::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) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In SelectClasses | |||||
PROCEDURE (10): SelectStudents (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | HMrkBrw5 | 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::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) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In SelectStudents | |||||
PROCEDURE (11): UpdateMajors (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 UpdateMajors | |||||
PROCEDURE (12): 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 (13): UpdateTeachers (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW3 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | HMrkBrw2 | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | BRW3::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0005) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0006) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(6) Class Instances Found In UpdateTeachers | |||||
PROCEDURE (14): BrowseTeachersCLARIONVIEW (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | TCHR | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 47 | ABBROWSE.INC |
(0003) | HMARK | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles9 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0007) | BRW1::Sort1:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0008) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0009) | BRW1::Sort1:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0010) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In BrowseTeachersCLARIONVIEW | |||||
PROCEDURE (15): 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 (16): UpdateEnrollment (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 UpdateEnrollment | |||||
PROCEDURE (17): BrowseMajors (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) | HMrkBrw4 | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0005) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0006) | BRW1::Sort1: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) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0010) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(10) Class Instances Found In BrowseMajors | |||||
PROCEDURE (18): UpdateStudents (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HDatePick | HNDDatePicker | HND | 73 | HNDDTPKR.INC |
(0002) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0003) | FileLookup6 | SelectFileClass | ABC | 5 | ABUTIL.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In UpdateStudents | |||||
PROCEDURE (19): BrowseStudents (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) | HMrkBrw7 | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.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) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0013) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(0014) | Resizer | WindowResizeClass | ABC | 25 | ABRESIZE.INC |
(14) Class Instances Found In BrowseStudents | |||||
PROCEDURE (20): BrowseTeachersDBVIEW (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | TCHR | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 47 | ABBROWSE.INC |
(0003) | HMARK | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles9 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0007) | BRW1::Sort1:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0008) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0009) | BRW1::Sort1:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0010) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In BrowseTeachersDBVIEW | |||||
PROCEDURE (21): UpdateClasses (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 UpdateClasses | |||||
PROCEDURE (22): BrowseEnrollmentDBVIEWNOABC (Procedure Template: Menu) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles5 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In BrowseEnrollmentDBVIEWNOABC | |||||
PROCEDURE (23): BrowseEnrollmentDBVIEW (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) | MARK | HNDMarkerBrowse | HND | 480 | HNDMRKBR.INC |
(0004) | Handles8 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0006) | BRW1::Sort0:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0007) | BRW1::Sort1:StepClass | StepClass | ABC | 6 | ABBROWSE.INC |
(0008) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0009) | BRW1::Sort1:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0010) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0011) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(11) Class Instances Found In BrowseEnrollmentDBVIEW | |||||