Browse Prior Art Database

Listing Data in User Panels Based on Referential Constraints

IP.com Disclosure Number: IPCOM000037158D
Original Publication Date: 1989-Nov-01
Included in the Prior Art Database: 2005-Jan-29
Document File: 1 page(s) / 11K

Publishing Venue

IBM

Related People

Payne, ME: AUTHOR

Abstract

Disclosed is a new end-user interface design which allows OS/2* Query Manager Panels to provide the list of valid values for a field based on a Referential Constraint. When a table is defined as a child in a referential constraint, values within columns of the table which are defined as the 'foreign key' must match the 'primary key' in a row of the parent table in the constraint. An error message will be displayed if the end user attempts to enter a value for the 'foreign key' which is not present in the 'primary key'. Based only on this message, an end user would not know what values are valid for the 'foreign key'.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 92% of the total text.

Page 1 of 1

Listing Data in User Panels Based on Referential Constraints

Disclosed is a new end-user interface design which allows OS/2* Query Manager Panels to provide the list of valid values for a field based on a Referential Constraint. When a table is defined as a child in a referential constraint, values within columns of the table which are defined as the 'foreign key' must match the 'primary key' in a row of the parent table in the constraint. An error message will be displayed if the end user attempts to enter a value for the 'foreign key' which is not present in the 'primary key'. Based only on this message, an end user would not know what values are valid for the 'foreign key'.

In many of the Query Manager screens, a 'List' function is provided which can be used to provide a list of valid values for a field. The design is to extend this function to provide listing for fields which are based on columns defined as part of a 'foreign key'; the 'List' function would be available in both user-defined Panels and in Data Edit.

The values to be listed are retrieved by first accessing the system catalogs to determine the columns in the parent table which correspond to the table being edited. The values in the parent table column corresponding to the cursored 'foreign key' column will be placed in the list.

Where there are already values present in other fields on the screen which are part of the 'foreign key', these values will be used to limit the list; i.e., only values...