Method and system for constructing database queries using a field selection grid
First Claim
1. A method in a computer system for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the computer system having a display device, the method comprising the steps of:
- displaying on the display device a selection grid having rows and columns, the selection grid having one of the rows designated as a field name row having empty fields for containing user-specified field names and one of the rows designated as a criteria row for containing selection criteria corresponding to the field name in the same column;
specifying by a user of the computer system one field name of the database table for which to specify a selection criterion;
displaying the user-specified field name in one of the empty fields of the field name row;
specifying by the user the selection criterion for the user-specified field name; and
displaying the specified selection criterion within the criteria row in a column corresponding to the user-specified field name.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system for constructing queries which make changes to an entire set of data stored in a database is provided. In a preferred embodiment of the present invention, a user selects one of more tables from which to construct a query. Next, the system stores a list box for each selected table. Each list box is displayed on a user interface including a query window which includes an upper portion and a lower portion. The user selects one or more columns from the list boxes and drags the selected columns into a QBE grid located in the lower portion of the query window. The QBE grid provides a graphical representation of the query requested by the user. When the user invokes the query, the system determines the query type and performs appropriate action on the selected column from the selected tables.
-
Citations
20 Claims
-
1. A method in a computer system for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the computer system having a display device, the method comprising the steps of:
-
displaying on the display device a selection grid having rows and columns, the selection grid having one of the rows designated as a field name row having empty fields for containing user-specified field names and one of the rows designated as a criteria row for containing selection criteria corresponding to the field name in the same column; specifying by a user of the computer system one field name of the database table for which to specify a selection criterion; displaying the user-specified field name in one of the empty fields of the field name row; specifying by the user the selection criterion for the user-specified field name; and displaying the specified selection criterion within the criteria row in a column corresponding to the user-specified field name. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method in a computer system for specifying a cross tabulation for a database table having a plurality of fields, each field having a field name, the computer system having a display device, the method comprising the steps of:
-
displaying on the display device a selection grid having rows and columns, one of the rows of the selection grid being designated as a field name row having empty fields for containing user-specified field names and another one of the rows of the selection grid being designated as a cross tabulation row; receiving, from a user of the computer system, the field names to use in the cross tabulation and displaying within the empty fields of the field name row of the selection grid the received field names; and receiving from the user a function of each of the displayed field names and displaying the received functions within the cross tabulation row, whereby the cross tabulation is generated in accordance with the displayed selection grid. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. A computer system for identifying a field name of a table for retrieving information from the table, the table having a plurality of field names, the computer system comprising:
-
a display device for displaying the plurality of field names; a query grid displayed on the display device, the query grid having a plurality of columns and a row designated as a field name row having empty fields for containing field names; and a pointing device for inserting into one of the empty fields of the field name row one of the displayed plurality of field names to identify the field name of the table from which to retrieve information.
-
-
17. A method, in a computer system having a display device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of:
-
displaying the plurality of field names of the database table in a first portion of the display device; displaying a query grid in a second portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and selecting by a user a field name from the displayed plurality of field names; displaying the selected field name in one column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the selected field name displayed in the field name row. - View Dependent Claims (18)
-
-
19. A method, in a computer system having a display device and a pointing device, for specifying selection criteria for retrieval of information from a database table having a plurality of fields with field names, the method comprising the steps of:
-
displaying the plurality of field names of the database table in a portion of the display device; displaying a query grid in another portion of the display device, the query grid having rows and columns, the query grid having one row designated as a field name row for containing user-selected field names and another row designated as a criteria row for containing selection criteria; and using the pointing device, selecting by a user a field name from the displayed plurality of field names; dragging the selected field name to a column of the field name row; and dropping the selected field name into the column of the field name row; specifying by the user a selection criterion for the selected field name; and displaying the specified selection criterion in a column of the criteria row corresponding to the dropped field name displayed in the field name row.
-
-
20. A method in a computer system for updating a database table having fields with field names, the computer system having a display device, the method comprising the steps of:
-
displaying on the display device an update grid having rows and columns, wherein one of the rows is designated as a field name row having empty fields for containing user-specified field names and another one of the rows is designated as an update row; specifying by a user of the computer system one field name of the database table; displaying the user-specified field name in one of the empty fields of the field name row; receiving from the user an update specification, the update specification specifying how to update the field with the displayed field name; and displaying in a column of the update row the update specification, whereby the computer system updates the database table in accordance with the update specification.
-
Specification