THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 163: PUBITEMSEXPORT

The query returns a list of Frank Lloyd Wright project drawing inventory numbers.

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 PUBITEMSEXPORT calls on Table Published/Drawings with a filter applied to Column [COCOMMENTS] (">0000") to select all records with a value on the row. The report format produced a block layout list intended to show bibliographic citations for published Frank Lloyd Wright drawings. The query structure, however, does not supply the data intended to present the information provided for in the report format; instead, only the Frank Lloyd Wright drawing inventory number appears in the report without the further information indicated by the Report Format image below.

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 163 query image

Report Format

JGDB10 Procedure 163 report form

Document: Dataease Procedure Definition Printout (PDF)