Re: What is QBE?

Posted in 1998

Claudio Duffini — Wed, 17 Jun 1998 08:15:38 +0100 — source: Informix-list mailing list archive (1991-1998)

POL wrote: > Since QBE stands for "Query By Example", yet i never see any > "example"??? Hi, POL ! Qbe is the notation used in construct 4gl statement. It is a way of making queries using *, |, >, <, :,? symbols. Quick examples: 1- Find records with date falling between 1/1/98 and 12/31/98 specify in the date field 1/1/98:12/31/98 2- Find records that have a char field beginning in A specify in the char field A* 3- Find records that have a Doe and Dae surname specify in the char field D?E 4- Find records with date over 1/1/98 specify in the date field >1/1/98 5- Find records with ZIP 12034, 30557, 10987 specify in the zip field 12034 | 30557 | 10987 Hope it helps Claudio Duffini