detail
- List of objects belonging to this band
functionname of type field
footer
footer
header
header
summary
summary
category
Field
- Field associated with column "category"
- Required field.
- Left aligned field.
functionname
Field
- Field associated with column "functionname"
- A maximum of 0 characters can be entered.
- Required field.
- Left aligned field.
help
Field
- Field associated with column "help"
- Required field.
- Left aligned field.
syntax
Field
- Field associated with column "syntax"
- Required field.
- Left aligned field.
data
DWData
release 5;
datawindow(units=0 timer_interval=0 color=1090519039 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no )
header(height=1 color="536870912" )
summary(height=4 color="536870912" )
footer(height=1 color="536870912" )
detail(height=55 color="536870912" )
table(column=(type=char(20) updatewhereclause=yes name=category dbname="category" )
column=(type=char(20) updatewhereclause=yes name=functionname dbname="functionname" )
column=(type=char(100) updatewhereclause=yes name=syntax dbname="syntax" )
column=(type=char(255) updatewhereclause=yes name=help dbname="help" )
sort="functionname A " )
data("Mathematic","Abs","Abs( ) ","Calculates the absolute value of a number.","Conversion","Asc","Asc( )","Converts the first character of a string to its ASCII integer value.","Statistic","Avg","Avg( for All )","Calculates the average of the values of the column.","Other","Bitmap","Bitmap ( ) ","Displays the named bitmap.","Other","Case","Case ( When Then ... Else )","Determines a value based on a set of condtion tests.","Mathematic","Ceiling","Ceiling( ) ","Determines the smallest whole number that is greater than or equal to a specified limit.","Conversion","Char","Char( ) ","Converts an integer to a character.","Mathematic","Cos","Cos( )","Calculates the cosine of an angle.","Statistic","Count","Count( for All )","Calculates the total number of rows in the specified column.","Statistic","CrossTabAvg","CrossTabAvg( 1 )","Calculates the average of the values returned by an expression in the values list of the crosstab.","Statistic","CrossTabCount","CrossTabCount( 1 )","Counts the number of values returned by an expression in the values list of the crosstab.","Statistic","CrossTabMax","CrossTabMax( 1 )","Calculates the maximum value returned by an expression in the values list of the crosstab.","Statistic","CrossTabMin","CrossTabMin( 1 )","Calculates the minimum value returned by an expression in the values list of the crosstab.","Statistic","CrossTabSum","CrossTabSum( 1 )","Calculates the sum of the values returned by an expression in the values list of the crosstab.","Statistic","CumulativePercent","CumulativePercent( for All )","Calculates the total value of the rows up to and including the current row in the specified column as a percentage of the total value of the column (a running percentage).","Statistic","CumulativeSum","CumulativeSum( for All )","Calculates the total value of the rows up to and including the current row in the specified column (a running total).","Form","CurrentRow","CurrentRow ( ) ","Determines the row which is current","Date/Time","Date","Date( ) ","Converts a string whose value is a valid date to a value of data type date.","Date/Time","DateTime","DateTime( ) ","Combines a date and a time value into a datetime value.","Date/Time","Day","Day( )","Obtains the day of the month in a date value.","Date/Time","DayName","DayName( )","Determines the day of the week in a date value and returns the weekday's name.","Date/Time","DayNumber","DayNumber( )","Determines the day of the week of a date value and returns the number of the weekday. ","Date/Time","DaysAfter","DaysAfter( , )","Determines the number of days one date occurs after another.","Form","Describe","Describe( ) ","Reports the values of attributes of the form and objects within the form.","Mathematic","Exp","Exp( x )","Raises e to the specified power.","Mathematic","Fact","Fact( ) ","Determines the factorial of a number.","String","Fill","Fill( , )","Builds a string of the specified length by repeating the specified characters until the result string is long enough.","Statistic","First","First( for All )","Determines the value in the first row in the specified column.","Form","GetRow","GetRow()","Reports the number of a row associated with a band in the form.","Form","GetText","GetText()","Obtains the text entered in a column.","Date/Time","Hour","Hour(