DADiSP Worksheet Functions > Function Categories > Query Functions > Query Functions

 

Query Functions

 

BUILTINS

List all available built-in functions

CHILDREN

Return number of children for the window

CLOCK

Return the current execution clock in seconds

COLNOS

Return an array of COL numbers

DELTAX

Return the delta-x value (1/sample rate) of a series

DELTAY

Return the delta-y value of an array

DIRPATH

Return the directory component of a path string

FINITE

Return 1 if input is finite

GETCOMMENT

Get comment string for first series in a window

GETCONF

Get value of configuration parameter as a string

GETCONFIG

Get value of configuration parameter

GETDATE

Get system date

GETEXENAME

Get path and name of executable

GETFOCUS

Get current series focus of a window

GETGCOLOR

Get global color parameter

GETGRIDCOLOR

Get color of the grids

GETGRIDSTYLE

Get style of the grids

GETHOME

Get the path to home directory

GETHUNITS

Get horizontal (X) units

GETLABEL

Get the label of the specified window

GETLABNAME

Get the name of current Labbook

GETLABPATH

Get the path to the current Labbook

GETMISCPATH

Get the path of a system folder

GETPALETTE

Return a series of the color indices used in palette

GETPLOTSTYLE

Return plotstyle of a series

GETPLOTTYPE

Return plottype of a multi-column series

GETSPLPATH

Return search path for SPL routines

GETSYMBOL

Return the type of symbol used for the specified series

GETSYMBOLINTERVAL

Return the symbol interval for the specified series

GETSYMBOLOFFSET

Return the start offset for a symbol plot

GETSYMBOLSIZE

Return the symbol size of a series

GETTIME

Get the system time

GETVUNITS

Get vertical (Y) units

GETWCOLOR

Get the color of a window

GETWCOUNT

Get the number of series in a window

GETWFORMULA

Get the formula for a window in string form

GETWINCURSORINFO

Return the setting for the level of information displayed in a Window formula line

GETWINNAME

Returns the symbolic name of a window

GETWMARGIN

Get percentage of margin for window

GETWNUM

Get the number of the current window

GETWORKSHEETNAME

Get the name of the current Worksheet

GETWSCOORDS

Get coordinates of dimensions of the current Worksheet

GETWSIZE

Get the window dimensions

GETWSXL

Get left coordinate of the current Worksheet

GETWSXR

Get right coordinate of the current Worksheet

GETWSYB

Get bottom coordinate of the current Worksheet

GETWSYT

Get top coordinate of the current Worksheet

GETXDATE

Get x axis range as a date value

GETXL

Get leftmost x-coordinate

GETXLABEL, GETYLABEL, GETZLABEL

Get x/y/z axis label

GETXLIDX

Get leftmost series y value

GETXR

Get rightmost x-coordinate

GETXRIDX

Get rightmost series y value

GETXTIC

Get x-axis tic interval

GETXTIME

Get X coordinate as a time value

GETYB

Get bottom y-coordinate

GETYL

Get leftmost y series value

GETYR

Get rightmost y series value

GETYT

Get top y-coordinate

GETYTIC

Get y-axis tic interval

GETZB

Return the bottom z coordinate of a Window

GETZT

Return the top z coordinate of a Window

GETZTIC

Return the z-axis tic interval of a Window

GETZUNITS

Get height (Z) units

ISARRAY

Return 1 is input is a series or array

ISCOMPLEX

Return 1 if input parameter is complex

ISDSNAME

Return 1 if string in dataset.ver.series form

ISDT

Return 1 if input is a series with date/time X units

ISEMPTY

Return 1 if input is an empty series

ISEQUAL

Return 1 if all inputs equal

ISFINITE

Returns 1 where series is finite

ISFUNC

Return 1 if input is a loaded SPL function

ISHANDLE

Return positive integer if value is a  shape or text handle

ISINF

Return 1 if input is infinite

ISMACRO

Return 1 if string is a macro

ISNAN

Return 1 if input is NaN

ISNUMERIC

Return 1 if input is a scalar or series

ISOBJECT

Return 1 if input as an ActiveX handle

ISPRIME

Return 1 if input is a prime number

ISREAL

Return 1 if input parameter is real

ISRT

Return 1 if input is a series with real time X units

ISSCALAR

Return 1 if input is a scalar

ISSTRING

Return 1 if input is a string

ISUNIT

Return 1 if string is a recognized engineering unit, else 0

ISVARIABLE

Return 1 is input is a variable name

ISWINDOW

Return 1 if input is a window or window reference

ISWINDS

Return 1 if window contains a saved series

ISWINEMPTY

Return 1 if window does not contain a series

ISXY

Return 1 if input is an XY series

ISXYZ

Return 1 if input is an XYZ series

ITEMCOL

Return the column number where the specified item starts

ITEMCOUNT

Return the number of columns in an item

ITEMTYPE

Return the item type of a composite series

LENGTH

Return length of series

NUMCOLS

Return the number of columns in a Window or DADiSP expression

NUMEL

Return total number of array elements

NUMFOCUS

Return the number of overlay foci.

NUMITEMS

Count number of items in window or matrix

NUMROWS

Return the number of rows in a Window or DADiSP expression

NUMWINDOWS

Return total number of windows in Worksheet

NUMVWINS

Return the number of displayed Windows in the Worksheet

OBJECTLIST

Return a string of available Labbooks, Worksheets, Datasets

PARENTS

Return number of parents of the window

RATE

Display sampling rate of the series

REALMAX

Return the largest positive real number

REALMIN

Return the smallest positive real number

ROWNOS

Return an array of row numbers

SERCOUNT

Count number of series in window or matrix

SERSIZE

Return length of series

SIZE

Return a 2 point series containing the dimensions of an array

TOC

Return the number of seconds since the internal timer started

UNITS

Display unit selections

WINSTATUS

Return the status of the current window

WRITECNF

Write the configuration table to an ASCII file

XOFFSET

Return the x offset of a series or table

XTIC

Return x-tic interval

YOFFSET

Return the y offset of an array

YTIC

Return y-tic interval

ZTIC

Return z-tic interval