Release 3.00
Mar 30, 2003
|
Sybernet / Supplied Procedures Reference
Release 3.00 Mar 30, 2003 |
|
VI allows you to query and edit any table and any column type. It is new and has not fully been tested so use at your own risk!
VI retrieves and updates rows based on their rowid. For updates, this guarantees that only the current row is altered. It also means that any table can safely be updated. A unique index is not required to use VI to edit a table.
Click the table you want to edit from the left margin. If you are in the wrong schema, select the schema name you want to edit from the drop-down list.
Use the following buttons to save your changes, scroll through the table, delete or find data in a table.
| Button | Description |
|---|---|
Save |
Save will either update an existing row or insert a new row.
A blank screen indicates that you are in insert mode which causes a new row to be inserted.
If you just retrieved a row, then clicking Save will update that row.
You can use the Reset button to clear the screen and enter insert mode.
If the save is successful, you will be prompted with an appropriate message if verbose mode is on. If the save is not successful, you will be prompted with an appropriate message regardless of whether verbose mode is on or off. The message is generated by Oracle and may not mean anything to you. A typical message might imply that one or more fields were not filled in. To correct, simply enter something into those fields. It is not possible to use VI to save or insert a row of all nulls. Should you retrieve such a row and then click Save, VI will actually delete that row. |
First |
First retrieves the first row in the table. The first row is that row with the smallest rowid. |
Next |
Next retrieves the next row in the table. If there are no more rows, Next will return a blank screen and enter insert mode. |
Scr+ |
This button scolls forward one row at a time automatically. It will stop when there are no more rows or when you click the Scr+ button again. |
Scr- |
Same as Scr+ except it scrolls in the reverse direction. |
Prev |
Same as Next except it scolls in the reverse direction. |
Last |
Same as first except it retrieves the last row in your table. |
Delete |
Delete will delete this row.
If you are in landscape mode, this button will (after confirmation) delete all rows on this screen. To delete one or more rows without deleting the entire screen, you can simply erase every field corresponding to the line or lines you want to delete and click Save. |
Find |
Find searches all rows in your table.
It will automatically search all columns except for those of type CLOB and BLOB.
When the Find window appears, enter the string you want to search.
When the results come back, click the link corresponding to the row you want to edit.
The search is both literal and case-insensitive. You can search on date values as long as you enter them (at least partially) in the default date format. Currently, the default date format is Mon dd yyyy HH:MIAM which means you can search for "Jul 24 2000" but not for 07/24/02. |
Reset |
Reset clears the screen. You are now in insert mode. |
Pref |
This button sets your preferences while in VI. When you save a new row or update a row, VI keeps that row in cache so that
if you save this row again, you save the same row. These preferences allow you to change this default behavior as well as
other options you may find useful:
Verbose mode doesn't actually interrupt what you are trying to do, but does invoke extra warnings or alerts that tell you what is actually happening when you click something. Verbose mode will alert you with a "success" message when a row is saved successfully, for example. Turn verbose mode off if this is not required. When checked, this option enters insert mode but does not erase the information on your screen. This mode is useful when you want to create several rows, but don't wish to have VI erase your fields. When checked, this option clears your screen and enters insert mode. This mode is useful when you want to create several rows with different information. When checked, this option will scroll your screen forward after a save. This mode is useful when you want to update several rows. This mode allows you to work in landscape mode where the layout looks more like a spread sheet. Use the drop-down list to specify how many rows on a screen you wish to edit at one time. In landscape mode and the number of rows is greater than one, clicking on one link of a find result will populate the first line of your screen with this row, but the remaining rows are populated in the usual way. |
Show |
This button displays the anonymous block that is submitted to Oracle when you click the Save button. This is either
an insert, update, or delete statement (or possibly a combination of all of these when in landscape mode).
It is for informational purposes only.
|
Each time you click a table name a new edit window and buttons are built. All of the fields on the edit window are null. You can either begin entering new rows or use one of the buttons to retrieve a row. All rows are accessed by their rowid, although this is done internally and you never actually see the rowid.
Each field is preceded by its column name. A mouseOver on the column name will reveal its internal datatype. Numeric and date fields are also validated.
The maximum blob (clob or blob) that can be retrieved or saved is 32,767 chars. If you attempt to retrieve a blob that exceeds this amount, an appropriate warning is displayed. You do not want to use this application to retrieve a clob larger than this amount and click the save button. If you do, your clob will be truncated.
Numeric data (number and float) are displayed right-aligned with commas in the expected position. Due to limitations in JavaScript, the maximum value that may be submitted is 999,999,999,999,999. If you need to enter numbers larger than this, you will have to do it yourself. VI also considers the number of decimal digits, by the way.
Although the default date format is Mon dd yyyy HH:MIAM, only the month, day, and year are displayed. The rest of the date is there which means you need to scroll over the field to edit it.