Project Description:
Sample code for reading and writing to an Access (or a SQL) database, and editing and displaying data in flexible grids, plus some other code pieces:
Details are:
A) Sample code - Panel and Frames
1) code to create a frame and then create multiple panels within the frame. Each panel will have a flexgrid (see C below)
2) code to add menu labels (File, Print, Help, Exit) to the panel and to the frame
B) Sample Code - Database Related:
3) code to connect and disconnect to a database with a password
4) code to insert and delete a Table in the database
5) code to insert and delete a Field in the database
6) code to insert a New Record, Update values in the record and Delete a record
7) code to rename a database
8) code to compress a database
9) code to replicate a database
10) In (5) and (6) above, the Field datatype can be: integer, long, single, Yes/No, boolean (true/false), text and date. So, sample code should show code lines for each of the datatypes (e.g. insert a Filed of type Date, insert a field of type boolean, update a boolean value in a record, etc.)
C) Sample Code -- Flexible Grid
11) code to create a flexgrid in a panel
12) code to create a grid with a user specified number of rows, columns, fixed rows and fixed columns
13) code to edit fore color and backcolor of any cell
14) code to edit font (size, bold/underline/italics) in any cell
15) code to adjust column width of any specified column
16) code to adjust row height of any specified column
17) code to hide/unhide any row or column
18) code to disable any cell, column or row
19) code to format a value (decimal points, integer, date format) in the cell
20) code of in-cell editing
21) code to display graphic symbols (like arrow head up/down/left/right) in the cell
22) the whole grid can be resized (and on resizing the fonts should automatically change in size)
23) the whole grid can be moved within a panel
C) Sample code -- Between the database and the Flexible Grid
24) code to update the Grid Display whenever the data being displayed is updated in the database changes
25) code to connect grid data with master symbol. For example if Grid1 and Grid2 are displaying values of Symbol1, then if symbol1 is a master symbol then if its value is updated/edited in Grid1, its value should also get updated in grid2 (similar to Group Grids/Windows)
