EvaluateInt Method
Description
Evaluates an expression which has an integer result.
Syntax
Visual Basic |
---|
Public Function EvaluateInt( _ ByVal objectType As Integer, _ ByVal nObject As Long, _ ByVal formula As String _ ) As Long |
Parameters
- objectType
-
SIS_OT_COMMAND
Changes the properties/mode of the current command. SIS_OT_CURITEM The current open Item. SIS_OT_DEFITEM
The default Item. SIS_OT_DATASET
Datasets. SIS_OT_OVERLAY
Overlays. SIS_OT_WINDOW
The window. SIS_OT_NOL
Named Object Libraries. SIS_OT_FTABLE
The current Feature Table. SIS_OT_SCHEMA
The current Schema. SIS_OT_SCHEMACOLUMN
A column in the current Schema. SIS_OT_THEME
The current Theme. SIS_OT_THEMECOMPONENT
A component in the current Theme. SIS_OT_PRINTER
Printer. SIS_OT_SYSTEM
System variables. SIS_OT_OPTION
System wide Boolean options. - nObject
- The index of the object type.
- formula
- The expression to evaluate. See Property Expression Syntax for details.
Return Type
The evaluated integer value of the given expression.
Remarks
- The following expression function enables you to find out what data type an attribute is.
VarType(...)
Which returns an enumeration, e.g. VarType(‘my_date@’) returns 7.
- Use it as part of Sis.EvaluateInt (for $&# datatypes) and Sis.Evaluate (for @ datatypes).
- The following formula translates these numbers into descriptive types:
Choose(VarType('attr@'),'Null','Short','Long (&)','Float','Double(#)', 'Currency','Date','String($)','','','Boolean','','','Decimal','Byte'. 'Unsigned Byte','Unsigned Short','Unsigned Long','Long Long Integer','Unsigned Long Long')
Substitute attr@ for your attribute name (including the $&#@ suffix).
VarType({...}) will also work with any lambda expression inside the {}.
For example:
VarType({DATE@})
The returned value will determine the data type for the queried column:
vbEmpty | 0 | Empty (uninitialized) |
vbNull | 1 | Null (no valid data) |
vbInteger | 2 | Integer |
vbLong | 3 | Long Integer |
vbSingle | 4 | Single |
vbDouble | 5 | Double |
vbCurrency | 6 | Currency value |
vbDate | 7 | Date value |
vbString | 8 | String |
vbObject | 9 | Object |
vbError | 10 | Error value |
vbBoolean | 11 | Boolean value (Zero and Non-zero) |
vbVariant | 12 | Variant (Array only) |
vbDataObject | 13 | A data access object |
vbByte | 17 | Byte |
vbUserDefinedType | 36 | Variants that contain user-defined types |
Available: GEO D OD OM OV SISpy
Group:
Example
sis.EvaluateInt ( SIS_OT_CURITEM , 0, "ItemID&" )