Browse Prior Art Database

Prompted Query Window (Echo) Management

IP.com Disclosure Number: IPCOM000119982D
Original Publication Date: 1991-Mar-01
Included in the Prior Art Database: 2005-Apr-02
Document File: 5 page(s) / 176K

Publishing Venue

IBM

Related People

Gaudet, JL: AUTHOR [+2]

Abstract

Disclosed is a method for managing the Prompted Query window which consists of echoes of what is contained within the Prompted Query Object.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 30% of the total text.

Prompted Query Window (Echo) Management

      Disclosed is a method for managing the Prompted Query
window which consists of echoes of what is contained within the
Prompted Query Object.

      Prompted Query is a program to create a SQL SELECT statement
via 'friendly' prompts or menus.  In the underlying window of a
Prompted Query it is represented as a series of selectable entries
(called 'echoes' since they are partially language dependent, and
they echo the contents of the actual Prompted Query object).

      In order to display a window of data, the information is
presented in two arrays.  Here, "arrays" refers to the organization
of a string of bytes into regular (all the same size), repeating
rows.  The first array defines whether or not the line is a valid
selection by the operator. The second array contains all the text
that is displayed to the operator. Both arrays have the same number
of rows, for obvious reasons.

      The following illustration shows a typical Prompted Query
underlying-window.  The lines which begin with an asterisk (*) are
the selectable entries, and are derived from the contents of the
first array. The asterisk is used here for symbolic purposes.

      Table:
* NULLID.STAFF(A)
* NULLID.STAFF(B)

      Join Tables:
* A.DEPT and B.DEPT

      Columns:
* A.NAME
* B.DEPT
* A.SALARY+A.COMM

      Rows:
* If A.SALARY Is Greater Than 1000
* And B.DEPT is Equal To 84

      Sort:
* Descending by A.SALARY+A.COMM

      Duplicates:
* Discard

      The non-selectable items are called 'headings' and allow the
user to readily identify what the selectable entries are used for
and/or represent.  We also use the 'headings' to refer to entries.
Thus, NULLID.STAFF(A) is a 'Table entry' because it is an entry and
appears under the 'Tables: heading'.  Also, A.DEPT is the '2nd Column
entry' because it is the second entry under the 'Columns: heading'.
All headings appear in the same relative order, although not all
headings (and thus their entries) are required.  Only the 'Tables:'
heading is required.  The maximum number of entries allowed for each
heading are as follows:
      Tables:      15
      Join Tables: 14, or 1 less than the number of Table
      entries.
      Columns:     no real limit.
      Rows:        no real limit.
      Sort:        no real limit
      Duplicates:  1

      NOTE: For simple presentation, for the rest of this disclosure
the phrases like 'Table entry' will simply appear as Table entry.

      The text that is presented to the operator is very
representational and does not have an exact 1-to-1 analog in the
Prompted Query Object being viewed.  The headings are shown in the
window to help the human operator; they have no analogous element in
the Prompted Query Object. The selectable items are human language
descriptions of a stored element (called a vector) in the Prompted
Query...