System Resources ORF Type

• List of all different ORF Types which may be used to classify the ORFs loaded into database.

• Fields

• Add New ORF Type
• Remove Rows
• Copy Rows
• Cut Rows
• Paste Rows
• Undo
• Load ORF Type File
• Save ORF Type File
• Save ORF Type
• Close ORF Type
• Refresh ORF Type

• General Comments
• See Also

Fields

• ORF Type No is the unique database number of the ORF Type.
• ORF Type is the name of the ORF Type.

Add New ORF Type

This adds a new row to the ORF Type resource table.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Add New ORF Type.

Note

• The table must be saved before changes in the database occur.

Remove Rows

This removes the selected rows from the ORF Type resource table.

1. Make the ORF Type window active in the Board.
2. Select one or more rows in the table.
3. On the ORF Type menu click Remove Rows.

Note

• The table must be saved before changes in the database occur.

Copy Rows

This copies the data in the selected rows of the ORF Type resource table to local clipboard.

1. Make the ORF Type window active in the Board.
2. Select one or more rows in the table.
3. On the ORF Type menu click Copy Rows.

Note

• The table must be saved before changes in the database occur.

Cut Rows

This removes the selected rows of the ORF Type resource table and copies them to local clipboard.

1. Make the ORF Type window active in the Board.
2. Select one or more rows in the table.
3. On the ORF Type menu click Cut Rows.

Note

• The table must be saved before changes in the database occur.

Paste Rows

This adds the rows in local clipboard to the ORF Type resource table.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Paste Rows.

Note

• The table must be saved before changes in the database occur.

Undo

This cancels the last change to the ORF Type resource table.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Undo.

Note

• The table must be saved before changes in the database occur.

Load ORF Type File

This loads a comma separated value file and adds the data to the ORF Type resource table.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Load ORF Type File.
3. In the folder list, locate and open the folder that contains the file.
4. Click the file, and then click Open.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.
• To see the exact file format, do a save file for a table with entries.
• The data in the table will be replaced with the data in the file.
• The table must be saved before changes in the database occur.

Save ORF Type File

This saves the ORF Type resource table as a comma separated value file.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Save ORF Type File.
3. If you want to save the file in a different folder, locate and open the folder.
4. In the File Name box, type a name for the file.
5. Click Save.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.

Save ORF Type

This saves the ORF Type in the database.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Save ORF Type, or click the Save ORF Type button in the button bar.

Note

• This will replace the information for the current ORF Type in the database.

Close ORF Type

This closes the window.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Close ORF Type, or click the X button on the window's Title bar.

Note

• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

Refresh ORF Type

This reverts the data for the ORF Type to the version in the database.

1. Make the ORF Type window active in the Board.
2. On the ORF Type menu click Refresh ORF Type.

Note

• This will reload the ORF Type from the database.
• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

General Comments

• To open the ORF Type window in the Board, on the Options menu select System Resources then click ORF Type.
• This System Resource is maintained by a Sesame user, usually a Sesame administrator, with a Can Do privilege.
• To give the Can Do privilege for this resource to user JoeSmith, execute the following SQL statement:
  insert into candothis values ('JoeSmith', 'SYS_RSC_ORFTYPE', 'Sesame', 'SYS');
• To revoke the Can Do privilege for this resource from user JoeSmith, execute the following SQL statement:
  delete from candothis where user_name='JoeSmith' and what='SYS_RSC_ORFTYPE' and ass_name='Sesame' and ass_type='SYS';

See also

Copyright © 1999-2009 Zsolt Zolnai, and the University of Wisconsin - Madison