초록 ▼

These and other objects, which will be apparent as the invention is more fully described, are provided by a method and system for constructing queries which make changes to an entire set of data stored in a database. In a preferred embodiment of the present invention, a user selects one or more tabl

These and other objects, which will be apparent as the invention is more fully described, are provided by a method and system for constructing queries which make changes to an entire set of data stored in a database. In a preferred embodiment of the present invention, a user selects one or 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.

대표청구항 ▼

[ We claim:] [1.] A method in a computer system for visually indicating joining a first table with a second table, each table having a plurality of fields, each field having a field name, the computer system having a display device, the method comprising:displaying on the display device the field na

[ We claim:] [1.] A method in a computer system for visually indicating joining a first table with a second table, each table having a plurality of fields, each field having a field name, the computer system having a display device, the method comprising:displaying on the display device the field names of the fields of the first table;displaying on the display device the field names of the fields of the second table;receiving from a user a selection of a displayed field name of the first table and of a displayed field name of the second table, the selection indicating that the first table and the second table are to be joined by the fields with the selected field names; anddisplaying on the display device a join indicator between the selected field names to indicate that the tables are to be joined by the fields of the selected field nameswherein the displaying of the field names displays the field names in a scrollable list box.