What it Does
The Calendar process provides the ability to track appointments and other events. It lets the user create event records and edit and retrieve calendar data.
The Calendar Screen
On the left, top of the window is a set of buttons arranged vertically. The first or top-most button should display this document. The next three buttons are window control buttons. The first button minimizes the window to the system tray. The next button toggles the window to stay on top of other windows or not. The third button closes the process.
To the right of those buttons is a calendar graphic button. Pressing that button displays any current or pending appointments or scheduled events. The "Scheduler" button to the right of the window title runs the Schedule process. The Schedule process lets the user schedule reminders and other events to be scheduled. The white boxes are for the entry of calendar data. Note that these boxes can be multi-line. That means that pressing Enter in a text object does not go to the next entry, it creates a new line in the object. To go to the next entry, try the tab key.
On the right beneath the last white entry box, is a light goldenrod colored box with a button above the left corner. This is a command/query box. Beneath the command box is a data grid. Above the right end of the data grid is a set of data control buttons. Above the data control buttons is a large goldenrod search box.
How It Works
The calendar button creates and displays the current appointments as a web page in the calendar process's on-board document viewer. It creates a file called "dailyapp.htm" in the application folder. Dates and times are inserted by right-clicking in a date or time box, selecting a date or time from the control that pops-up, and pressing the "Enter" key.
The data grid displays the records in the calendar database. To edit a record shown in the data grid, select the record by clicking in the grid and then right-click to place the record in the editing boxes.
The user can enter TCB functions and windows commands in the command/query box as though the box was a batch file. Pressing the button above the command box executes the command lines with the TCB function processor. Entering a SQLite query in the box and double-clicking will cause the query to be processed by the TCB SQL query processor.
The search box responds to two datas. The first is to simply enter a rsid number and right or double-clicking the search box. This puts the record with that number in the entry boxes. The other search method is to enter a SQL where clause and right or double-clicking.
A where clause has the format:
where [dataitem] [=|!=| >| <| like] 'data'
SQL where example:
where lnam like 'data'
Calendar where example, note no where word:
subject like '%dance%'
Means return the first record with the word dance contained in the "subject" column.
To add new records, simply type over or delete data from the entry boxes and press the Add data control button. If you want to change data in a record, just type in what you want and press the Update data control button. To delete a record, press the data control Delete button. Use the arrow data control buttons to scroll through the calendar records.
Copyright © 1982-2016 Phoenix Information Systems/TM all rights reserved
Contact: Fred Pierce, makpiya@aol.com, makpiya@gmail.com, 831.240.9969