2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Operators
Using Calculations - 229
Operators — Quick Reference
See “Usage Conventions” on page 9-227 for information on how to
interpret the examples in the following table.
Operator Type Description Usage Example
+
mathematical Addition: add numbers or fields [num1] + [num2]
-
mathematical Subtraction: subtract numbers or fields [num1] - [num2]
*
mathematical Multiplication: multiply numbers or fields [num1] * [num2]
/
mathematical Division: divide numbers or fields [num1] / [num2]
^
mathematical Power of: raise a number or field by a power [num1]^2
&
text Concatenate: put together strings “str1”&”str2”
=
comparison Equal: compare values or results If ([num1]=[num2], true exp, false exp)
<>
comparison Not Equal: compare values or results If ([num1]<>[num2], true exp, false exp)
<
comparison Less Than: compare values or results If ([num1]<[num2], true exp, false exp)
>
comparison Greater Than: compare values or results If ([num1]>[num2], true exp, false exp)
<=
comparison Less Than or Equal to: compare values or
results
If ([num1]<=[num2], true exp, false exp)
>=
comparison Greater Than or Equal to: compare values or
results
If ([num1]>=[num2], true exp, false exp)
And
logical Logical And: use with Logical If to put together
more than one condition. All conditions must
be true for the Logical If function to be true.
If ([num1]=[num2] And
[num3]=[num4], true exp, false exp)
Or
logical Logical Or: use with Logical If to include more
than one condition. Only one condition must
be true for the Logical If function to be true.
If ([num1]=[num2] Or [num3]=[num4],
true exp, false exp)
Not
logical Logical Not: used with the Logical If function
to negate a condition.
If ([num1]=[num] And NOT
[num3]=[num4], true exp, false exp
()
mathematical Left and Right Parentheses: show precedence.
A matching set of parentheses must exist.
([num1]+[num2]) * 3
“ ”
text Constant Quotes: mark the beginning and
end of a character used as a constant or
characters used as a text string. A matching
set of quotes must exist.
“John Doe”