The Contacts process provides the ability to track contacts and other address information. It lets the user create contact records and edit and retrieve contact data.
The Contacts 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 and below those buttons are white boxes are for the entry of contacts 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 data grid displays the records in the contacts 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. If the user double-clicks a phone number, the contacts process will try to dial the number if the system has a phone modem connection.
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'
Contacts where example, note no where word:
lnam like '%rog%'
Means return the first record with the word rog contained in the "lnam" 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