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
Functions
Using Calculations - 248
Sign
The Sign function returns a value of 1 if a number or numeric expression
is positive, -1 if it is negative, and 0 if it is 0.
Usage Example
Sign([num1])
If the field [num1] = -100
Then the calculation Sign([num1]) returns -1
In the example below, the
Invoice Amount
field is evaluated and a
message is put in the
Warning
field if it is negative. The Sign function is
used to determine if the value is negative.
Sqrt (Square Root)
The Sqrt function returns the square root of a number or numeric
expression. The number or numeric expression must be positive.
Usage Example
Sqrt([num1])
If the field [num1] = 8
Then the calculation Sqrt([num1]) returns 2.82842712
In the example below, the square root is calculated using the
Number
field and put in the
Square Root
field. The Round calculation is used to
round the result to three decimal places.