You can easily search the database for information and add or update data in the database by using the QMF interactive Table Editor. The Table Editor has three modes: SEARCH, ADD, or CHANGE.
The Table Editor enables quick searching, adding, deleting, and updating of rows in any accessible table without requiring you to write a unique application. The Table Editor also supports default column values when a default is available. The following screen shows a representative panel.
ADD USERID.PERS
1 to 7 of 7
ACCTNO. . . . . . . . (_15002__)
COMPANY . . . . . . . (_S & J Supply Co.__________)
STREET. . . . . . . . (_948 C Street_________)
CITY. . . . . . . . . (_Boston_______________)
STATE . . . . . . . . (_MA_)
ZIP . . . . . . . . . (_06000__)
NOTES . . . . . . . . (_-__________________________________________________>
Editing data is as easy as typing over the values on the Table Editor panel. Confirmation panels help ensure security and integrity by prompting the user before making any updates final. For extra security, you can also use column-level authorization to control exactly which columns of a table a user can view or change.
In QMF for Windows, you can edit a table at a database server by making changes to cells displayed in query results. QMF for Windows determines the table to edit from the SQL text for the query. You can update the results of most queries that you can run with QMF for Windows.