FIND — FREEALLOC

Contents

• FIND — Searches data file fields for matching string
• FINDFIELD — Searches data file fields for matching string
• FIRST — Positions to the first record
• FIX$ — Converts a number to a string
• FLAGS — Sets an application’s system flags
• FLT — Converts an integer to a floating point number
• FONT — Sets the text window’s font and style
• FREEALLOC — Frees a previously allocated cell

FIND — Searches data file fields for matching string

Usage:      f%=FIND(a$)

Warning: this language keyword is deprecated; its functionality has been replaced by DbFind&: in SysRam1.opx.

FINDFIELD — Searches data file fields for matching string

Usage:      f%=FINDFIELD(a$,start%,no%,flags%)

Warning: this language keyword is deprecated; its functionality has been replaced by DbFindField&: in SysRam1.opx.

FIRST — Positions to the first record

Usage:      FIRST

Positions to the first record in the current view.

See Database manipulation.

FIX$ — Converts a number to a string

Usage:      f$=FIX$(x,y%,z%)

Returns a string representation of the number x, to y% decimal places. The string will be up to z% characters long.

Example: FIX$(123.456,2,7) returns "123.46".

• If z% is negative then the string is right-justified for example FIX$(1,2,-6) returns " 1.00" where there are two spaces to the left of the 1.
• If z% is positive then no spaces are added for example FIX$(1,2,6) returns "1.00".
• If the number x will not fit in the width specified by z%, then the string will just be asterisks, for example FIX$(256.99,2,4) returns "****".

See also GEN$, NUM$, SCI$.

FLAGS — Sets an application’s system flags

Usage:      FLAGS flags%

Used within an APP…ENDA construct to provide the OPL application’s system flags. Possible values for flags% are:

These constants can be added together to combine their effects. They are supplied in Const.oph.

FLAGS may only be used within the APP…ENDA construct.

See also APP and OPL applications.

FLT — Converts an integer to a floating point number

Usage:      f=FLT(x&)

Converts an integer expression (either integer or long integer) into a floating-point number. Example:

    PROC gamma:(v)
          LOCAL c
          c=3E8
          RETURN 1/SQR(1-(v*v)/(c*c))
    ENDP

You could call this procedure like this: gamma:(FLT(a%)) if you wanted to pass it the value of an integer variable without having first to assign the integer value to a floating-point variable.

See also INT and INTF.

FONT — Sets the text window’s font and style

Usage: FONT id&,style%

Sets the text window font and style. The standard font IDs are:

Standard font styles are:

All these constants are provided in Const.oph.

See The text and graphics windows for more details.

FREEALLOC — Frees a previously allocated cell

Usage: FREEALLOC pcell&

Frees a previously allocated cell at pcell&.

See also SETFLAGS if you require the 64K limit to be enforced. If the flag is set to restrict the limit, pcell& is guaranteed to fit into a short integer.