| Name: | ISTAT | Syntax: | ISTAT('keyword') |
|---|---|---|---|
| Family: | Function | Category: | Keyboard and Environment |
| Description: | Returns mouse and cursor screen coordinates, and feedback regarding database activity. | ||
Returns the current value or setting of 'keyword'.
Using ISTAT parameters, you can determine database activity, and the current mouse and cursor column or row coordinates.
Use ISTAT to check the efficiency of settings to adjust locking scheme. You should be able to see differences in the results returned by the ISTAT keywords TOTALREADS, TOTALWRITES, and TOTALLOCKS depending on the locking scheme you have set.
The ISTAT function has a number of options that report on available memory in the dynamic data area R:BASE uses for processing in the DOS version. The amount of available extended memory in the DOS version of R:BASE and how that memory is allocated is not checked or displayed by any parameters of the ISTAT function.
You must either enclose the keyword in quotation marks or use a dot variable
that has a TEXT data type to which
you have assigned the SHOW keyword.
You can use majority of SHOW keywords with CVAL, as well as DATABASE, DBPATH, CURRDIR.
Folowing keywords can be used for (CVAL('Keyword')):
To reset the counter for TOTALREADS, TOTALWRITES, and TOTALLOCKS, use the SET VARIABLE command with the ISTAT function.
Note: Since the ISTAT function can operate if only a part of a parameter is matched, you should not abbreviate the ISTAT keywords. ISTAT returns column coordinates for an abbreviation of "MOUSE" and "CURSOR"; for example, (ISTAT('mouse')) returns the mouse column because "COL" is matched before "ROW."