Method and apparatus for database filter generation by display selection

摘要: A method for selecting records from a displayed database table by generating an SQL SELECT command filtering the in accordance with cell values highlighted user input. presently selected set of desired (generally referred to as record or source) are on user's display screen. The selects particular cells (an intersection row and column table) highlighting using pointer device keyboard computer system. Methods present invention then generate select (filter) selectively retrieve those which match values. fully indicates exact equality is user, beginning portion that wishes whose corresponding starts value, ending selection matches qualified records, middle any containing value. Values same logically AND'd clauses while comparison generated OR'd comparisons other rows. may indicate (inclusion records) exclusion (exclusion records). new be prior filter permit complex criteria defined simple graphical inputs.