4D v14.3
OBJECT SET FILTER
- 4D Language Reference
-
- Objects (Forms)
-
- Object Properties
- GET STYLE SHEET INFONew
- LIST OF STYLE SHEETSNew
- OBJECT DUPLICATE
- OBJECT Get actionNew
- OBJECT Get auto spellcheck
- OBJECT GET BEST SIZE
- OBJECT Get border styleNew
- OBJECT Get context menuNew
- OBJECT GET COORDINATES
- OBJECT Get data sourceNew
- OBJECT GET DRAG AND DROP OPTIONS
- OBJECT Get enabled
- OBJECT Get enterable
- OBJECT GET EVENTSNew
- 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 typeNew
- OBJECT Get keyboard layout
- OBJECT Get list nameUpd
- OBJECT Get list referenceNew
- OBJECT GET MAXIMUM VALUENew
- OBJECT GET MINIMUM VALUENew
- OBJECT Get multilineNew
- OBJECT Get placeholderNew
- OBJECT GET PRINT VARIABLE FRAMENew
- OBJECT GET RESIZING OPTIONS
- OBJECT GET RGB COLORS
- OBJECT GET SCROLL POSITION
- OBJECT GET SCROLLBARUpd
- OBJECT GET SHORTCUT
- OBJECT Get style sheetNew
- OBJECT GET SUBFORM
- OBJECT GET SUBFORM CONTAINER SIZE
- OBJECT Get text orientationNew
- OBJECT Get three states checkboxNew
- OBJECT Get title
- OBJECT Get typeNew
- OBJECT Get vertical alignment
- OBJECT Get visible
- OBJECT Is styled textNew
- OBJECT MOVE
- OBJECT SET ACTIONNew
- OBJECT SET AUTO SPELLCHECK
- OBJECT SET BORDER STYLENew
- OBJECT SET COLOR
- OBJECT SET CONTEXT MENUNew
- OBJECT SET COORDINATESNew
- OBJECT SET DATA SOURCENew
- OBJECT SET DRAG AND DROP OPTIONS
- OBJECT SET ENABLED
- OBJECT SET ENTERABLE
- OBJECT SET EVENTSNew
- OBJECT SET FILTER
- OBJECT SET FOCUS RECTANGLE INVISIBLE
- OBJECT SET FONT SIZE
- OBJECT SET FONT STYLE
- OBJECT SET FONTUpd
- OBJECT SET FORMAT
- OBJECT SET HELP TIP
- OBJECT SET HORIZONTAL ALIGNMENT
- OBJECT SET INDICATOR TYPENew
- OBJECT SET KEYBOARD LAYOUT
- OBJECT SET LIST BY NAMEUpd
- OBJECT SET LIST BY REFERENCENew
- OBJECT SET MAXIMUM VALUENew
- OBJECT SET MINIMUM VALUENew
- OBJECT SET MULTILINENew
- OBJECT SET PLACEHOLDERNew
- OBJECT SET PRINT VARIABLE FRAMENew
- OBJECT SET RESIZING OPTIONS
- OBJECT SET RGB COLORSUpd
- OBJECT SET SCROLL POSITION
- OBJECT SET SCROLLBARUpd
- OBJECT SET SHORTCUT
- OBJECT SET STYLE SHEETNew
- OBJECT SET SUBFORM
- OBJECT SET TEXT ORIENTATIONNew
- OBJECT SET THREE STATES CHECKBOXNew
- OBJECT SET TITLE
- OBJECT SET VERTICAL ALIGNMENT
- OBJECT SET VISIBLE
- DISABLE BUTTON
- 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 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: Objects (Forms)
Number:
235
Modified: 4D v6
Renamed: 4D v12
OBJECT Get filter
OBJECT SET FORMAT
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
Inherited from : SET FILTER ( 4D v11 SQL Release 6)
