Pathmaker Reference Manual

Record Instance Detail Screen
Pathmaker Screens
1–78 067869 Tandem Computers Incorporated
Standard Database Services
Enter Y or N for the fields under the Standard Database Services to control:
Your ability to delete, insert, read, or update the record or table from the database.
For a parent record, the requester's ability to automatically read the first record as
its initial action.
For a child record, the requester's ability to obtain automatically a matching child
record whenever a parent record is read.
Insert
Enter Y to insert records or rows. Enter N to prevent insertions.
Delete
Enter Y to delete records or rows. Enter N to prevent deletion.
If you enter Y for this field, you must also enter Y for the Read field.
Update
Enter Y to update records or rows. Enter N to prevent updating.
If you enter Y for this field, you must also enter Y for the Read field.
Read
Enter Y to read records or rows. Enter N to prevent the reading of records or rows in
the database.
Nonindex Reads
Enter Y to read rows by NonStop SQL columns that have no efficient index. Enter N
to prevent reading of rows by NonStop SQL columns that have no index.
If you are using the null values feature of NonStop SQL and you want to read by a
column that accepts null values, this field must be Y.
For ENSCRIBE records, this field must be N.
Factors that make a column inefficient as part of an index are:
If the column accepts null values.
If using the column means mixing ascending and descending columns.
Autofill
Enter Y if you want your application to display information automatically on the
application screen. Enter N if you do not want any automatic data retrieval for this
record.
The effects of autofill vary depending on whether the record is joined to another
record and whether the DDL description of the record includes a VALUE clause.