 |
Database Window |
Click this button on the Toolbar to view a list of all the
tables in the MySQL database. Click a table name in the Database Window
to open that table in Dataview. |
 |
Dataview |
Three fields are excluded from the Dataview: the auto-number 'ID',
'date_created' and 'userkey'. These are all required fields but are controlled strictly by
the program. The 'ID' field does appear for reference only in the Update, Add and Filter
forms. |
  |
Delete record |
Records can only be deleted singly. Confirmation of your intention will be required
and notice of successful deletes will be given. Refresh the Dataview to
see the change if AutoRefresh is not on. |
 |
Edit record |
The Update Record form can be escaped using the close button. Notice
of successful updates will be given. If no changes were made the update will be deemed
unsuccessful. Refresh the Dataview to see the change if AutoRefresh
is not on. |
 |
Add record |
The Add Record form (available at the bottom of every table) can be
escaped using the close button. Notice of successful additions will be given. Refresh the Dataview
to see the change if AutoRefresh is not on. |
 |
AutoRefresh
On/Off |
This button, when pressed in, will call for the Dataview to be
refreshed whenever a change has been made. Leave it off when the refresh time for large
tables slows down multiple changes. |
 |
Filter By Form |
The Filter By Form form is like that for editing and adding records.
It accepts any input in any field to narrow down the record selection of the Dataview
to those matching your input. Leaving all fields blank will return all records. |
 |
Filter
On/Off |
When a filter is applied to a table this button will appear pressed in.
Toggle it off and on to remove and restore the filter. |
 |
Add record |
This button does the same as the one at the bottom of every table |
  |
Sort |
The Toolbar should already indicate, beside the Database icon, which
table is opened in Dataview. If you click on any Field header in the Dataview
window it will appear on the Toolbar between these two Sort icons. Click
on either the Acscending or Descending Sort buttons to requery the table and present it in
the requested sort order. Subsequent sorts are added to the existing sort order |
 |
Replicate |
This button will open a directory listing of SQL files (on the server) that have been
previously uploaded as a step towards creating, deleting or updating MySQL tables. Click a
file name to select that file for further actions. |
 |
Exectute File Statements |
The selected file (appearing to the left of this button) will be displayed for
confirmation. Click OK to process all of the SQL statements in this file, or Cancel. |
 |
Delete File |
Confirm your intention to delete the selected file, or Cancel. |
 |
Upload Files |
This button will open the Upload Files to Server form allowing you to
browse your local computer and select up to three files for uploading to the
'import' directory on the server. Only .sql and .txt files are allowed and only files
specially designed to work in the MySQL environment will be of any use here. In any
real environent, access to this facility would be restricted. |
 |
Database Password Entry |
Use the Database Password Entry form to register a userkey for access
to records that require one. The Dataview window will indicate whether you have editing
rights to a record by showing Delete and Edit buttons to
be enabled or disabled. You can still try your luck with disabled buttons by supplying a
userkey to each record individually. |
|
|
|
|
|
|
|
|
|
