4D v16.3
OBJECT SET FILTER
- 4D Language Reference
-
- Objects (Forms)
-
- Object Properties
- GET STYLE SHEET INFO
- LIST OF STYLE SHEETS
- OBJECT DUPLICATE
- OBJECT Get action
- OBJECT Get auto spellcheck
- OBJECT GET BEST SIZE
- OBJECT Get border style
- OBJECT Get context menu
- OBJECT GET COORDINATES
- OBJECT Get corner radius
- OBJECT Get data source
- OBJECT GET DRAG AND DROP OPTIONS
- OBJECT Get enabled
- OBJECT Get enterable
- OBJECT GET EVENTS
- OBJECT Get filter
- OBJECT Get focus rectangle invisible
- OBJECT Get font
- OBJECT Get font size
- OBJECT Get font style
- OBJECT Get format
- OBJECT Get help tip
- OBJECT Get horizontal alignment
- OBJECT Get indicator type
- OBJECT Get keyboard layout
- OBJECT Get list name
- OBJECT Get list reference
- OBJECT GET MAXIMUM VALUE
- OBJECT GET MINIMUM VALUE
- OBJECT Get multiline
- OBJECT Get name
- OBJECT Get placeholder
- OBJECT Get pointer
- OBJECT GET PRINT VARIABLE FRAME
- OBJECT GET RESIZING OPTIONS
- OBJECT GET RGB COLORS
- OBJECT GET SCROLL POSITION
- OBJECT GET SCROLLBAR
- OBJECT GET SHORTCUT
- OBJECT Get style sheet
- OBJECT GET SUBFORM
- OBJECT GET SUBFORM CONTAINER SIZE
- OBJECT Get text orientation
- OBJECT Get three states checkbox
- OBJECT Get title
- OBJECT Get type
- OBJECT Get vertical alignment
- OBJECT Get visible
- OBJECT Is styled text
- OBJECT MOVE
- OBJECT SET ACTION
- OBJECT SET AUTO SPELLCHECK
- OBJECT SET BORDER STYLE
- OBJECT SET COLOR
- OBJECT SET CONTEXT MENU
- OBJECT SET COORDINATES
- OBJECT SET CORNER RADIUS
- OBJECT SET DATA SOURCE
- OBJECT SET DRAG AND DROP OPTIONS
- OBJECT SET ENABLED
- OBJECT SET ENTERABLE
- OBJECT SET EVENTS
- OBJECT SET FILTER
- OBJECT SET FOCUS RECTANGLE INVISIBLE
- OBJECT SET FONT
- OBJECT SET FONT SIZE
- OBJECT SET FONT STYLE
- OBJECT SET FORMAT
- OBJECT SET HELP TIP
- OBJECT SET HORIZONTAL ALIGNMENT
- OBJECT SET INDICATOR TYPE
- OBJECT SET KEYBOARD LAYOUT
- OBJECT SET LIST BY NAME
- OBJECT SET LIST BY REFERENCE
- OBJECT SET MAXIMUM VALUE
- OBJECT SET MINIMUM VALUE
- OBJECT SET MULTILINE
- OBJECT SET PLACEHOLDER
- OBJECT SET PRINT VARIABLE FRAME
- OBJECT SET RESIZING OPTIONS
- OBJECT SET RGB COLORS
- OBJECT SET SCROLL POSITION
- OBJECT SET SCROLLBAR
- OBJECT SET SHORTCUT
- OBJECT SET STYLE SHEET
- OBJECT SET SUBFORM
- OBJECT SET TEXT ORIENTATION
- OBJECT SET THREE STATES CHECKBOX
- OBJECT SET TITLE
- OBJECT SET VERTICAL ALIGNMENT
- OBJECT SET VISIBLE
- _o_DISABLE BUTTON
- _o_ENABLE BUTTON
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 Object Properties section.
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: Objects (Forms)
Number:
235
Modified: 4D v6
Renamed: 4D v12
4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)
