4D v13.4
OBJECT SET FILTER
- 4D Language Reference
-
- Object Properties
-
- Object Properties
- DISABLE BUTTON
- ENABLE BUTTON
- OBJECT DUPLICATE
- OBJECT Get auto spellcheckNew
- OBJECT GET BEST SIZE
- OBJECT Get choice list name
- OBJECT GET COORDINATES
- OBJECT GET DRAG AND DROP OPTIONSNew
- OBJECT Get enabled
- OBJECT Get enterable
- OBJECT Get filter
- OBJECT Get focus rectangle invisibleNew
- OBJECT Get font
- OBJECT Get font size
- OBJECT Get font style
- OBJECT Get format
- OBJECT Get help tipNew
- OBJECT Get horizontal alignment
- OBJECT Get keyboard layoutNew
- OBJECT Get plain text
- OBJECT GET RESIZING OPTIONSNew
- OBJECT GET RGB COLORS
- OBJECT GET SCROLL POSITION
- OBJECT GET SCROLLBAR
- OBJECT GET SHORTCUTNew
- OBJECT Get styled text
- OBJECT GET STYLED TEXT ATTRIBUTES
- OBJECT GET SUBFORM CONTAINER SIZENew
- OBJECT GET SUBFORMNew
- OBJECT Get title
- OBJECT Get vertical alignmentNew
- OBJECT Get visible
- OBJECT MOVE
- OBJECT SET AUTO SPELLCHECKNew
- OBJECT SET CHOICE LIST NAME
- OBJECT SET COLOR
- OBJECT SET DRAG AND DROP OPTIONSNew
- OBJECT SET ENABLED
- OBJECT SET ENTERABLE
- OBJECT SET FILTER
- OBJECT SET FOCUS RECTANGLE INVISIBLENew
- OBJECT SET FONT
- OBJECT SET FONT SIZE
- OBJECT SET FONT STYLE
- OBJECT SET FORMAT
- OBJECT SET HELP TIPNew
- OBJECT SET HORIZONTAL ALIGNMENT
- OBJECT SET KEYBOARD LAYOUTNew
- OBJECT SET PLAIN TEXT
- OBJECT SET RESIZING OPTIONSNew
- OBJECT SET RGB COLORS
- OBJECT SET SCROLL POSITION
- OBJECT SET SCROLLBAR
- OBJECT SET SHORTCUTNew
- OBJECT SET STYLED TEXT
- OBJECT SET STYLED TEXT ATTRIBUTES
- OBJECT SET SUBFORMNew
- OBJECT SET TITLE
- OBJECT SET VERTICAL ALIGNMENTNew
- OBJECT SET VISIBLE
OBJECT SET FILTER
| OBJECT SET FILTER ( {* ;} object ; entryFilter ) | ||||||||
| Parameter | Type | Description | ||||||
| * | Operator |
|
If specified, Object is an Object Name (String) If omitted, Object is a Field or a Variable | |||||
| object | Form object |
|
Object Name (if * is specified), or Field or Variable (if * is omitted) | |||||
| entryFilter | String |
|
New data entry filter for the enterable area | |||||
OBJECT SET FILTER sets the entry filter for the objects specified by object to the filter you pass in entryFilter.
If you specify the optional * parameter, you indicate an object name (a string) in object. If you omit the optional * parameter, you indicate a field or a variable in object. In this case, you specify a field or variable reference (field or variable objects only) instead of a string. For more information about object names, see the section Object Properties.
OBJECT SET FILTER can be used for input and dialog forms and can be applied to fields and enterable variables that accept an entry filter in the Design environment.
Passing an empty string in entryFilter removes the current entry filter for the objects.
Note: This command cannot be used with fields located in a subform’s list form.
Note: In entryFilter, to use entry filters you may have predefined using the Tool Box, prefix the name of the filter with a vertical bar (|).
The following example sets the entry filter for a postal code field. If the address is in the U.S., the filter is set to ZIP codes. Otherwise, it is set to allow any entry:
If([Companies]Country="US") ` Set the filter to a ZIP code format
OBJECT SET FILTER([Companies]ZIP Code;"&9#####")
Else ` Set the filter to accept alpha and numeric and uppercase the alpha
OBJECT SET FILTER([Companies]ZIP Code;"~@")
End ifThe following example allows only the letters “a,” “b,” “c,” or “g” to be entered in two places in the field Field:
OBJECT SET FILTER([Table]Field ;"&"+Char(Double quote)+"a;b;c;g"+Char(Double quote)+"##")Note: This example sets the entry filter to &"a;b;c;g"##.
Product: 4D
Theme: Object Properties
Number:
235
Modified: 4D v6
Renamed: 4D v12
OBJECT Get filter
OBJECT SET FORMAT
