d_dwfunction


pfcdwsrv.pbl   >   d_dwfunction   

Last Update 13/03/2008 09:54:51
Size 26 362 bytes
No Data
detail
 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( 
, , )","Obtains the integer value of a setting in the specified profile file.","Other","ProfileString","ProfileString( ,
, , )","Obtains the string value of a setting in the specified profile file.","Other","Rand","Rand( ) ","Obtains a random whole number between 1 and a specified upper limit.","Conversion","Real","Real( ) ","Converts a string value to a real data type.","Date/Time","RelativeDate","RelativeDate( , )","Obtains the date that occurs a specified number of days after or before another date.","Date/Time","RelativeTime","RelativeTime(