4D v14.3Query by example |
||||||||||||||||||||
|
4D v14.3
Query by example
Query by example
The Query by Example option is a convenient way to perform many queries. In this type of query, you use the current input form to enter values on which to base the search. You can only search in fields of the current table. Query by Example performs both indexed and sequential queries. The Query by Example window shown is just an example. Your current input form is always used as the Query by Example window. You can control the appearance of the Query by Example window by changing the current input form. You can use comparison operators in Query by Example. For example, to use the “is equal to” comparison operator, enter the value to be searched for in the appropriate field. If you need a different comparison operator, precede the value with one of the following signs:
You can request a “Begins with” query by placing the wildcard character (@) after the value to be searched for. The following figure shows the Query by Example window being used to search for all companies whose names begin with “S”. You can create a compound query by typing values into more than one field. If you enter a compound query, the And conjunction is assumed (e.g., “Name starts with “S” and is in California”). The following Query by Example window illustrates a compound query. To use Query by Example:
|
PROPERTIES
Product: 4D ARTICLE USAGE
4D Design Reference ( 4D v14 R2) |
||||||||||||||||||