THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 85: JGBOOKLIBX2

The query returns a list of books and periodicals not related to Frank Lloyd Wright found in the library of John Geiger.

Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

PROCEDURE NOTES

Procedure JGBOOKLIBX2 calls on Table MMJGBKLB, but the query structure is anomalous. There is no Column [X] in the table against whtich a filter is set ("2"). There is also no Column [P], which would have ordered the results. The query could not execute. The comment in the Report Format image below states, "Non Frank Lloyd Wright material published in 1990 or prior to that date"; however, there is no date range selected in the query structure. The report format would have produced a block layout list with extensive bibliographical and valuation information.

The query structure is the same as Proc in Database JGDB10, except that the date range there is is applied correctly.

Database Search

Search based on this procedure cannot be executed through the version of the database available on the website.

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 85 query image

Report Format

JGDB10 Procedure 85 report form

Document: Dataease Procedure Definition Printout (PDF)