Context (This...)

Top  Previous  Next

 

These functions are special in that the access values related to where the function is used.  See the Expression Context section for more details.

 

 

 

(Back to Function Types List)

 

 

Function:Cust        
Result-type:Record        
Arguments:(none)        
Description:Returns the Customer record of interest, if used where there's a specific customer (or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). A shorter version of ThisCust().        

 

 

Function:Park        
Result-type:Record        
Arguments:(none)        
Description:Returns the Park record of interest, if used where there's a specific park (or site or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). A shorter version of ThisPark().        

 

 

Function:Resv        
Result-type:Record        
Arguments:(none)        
Description:Returns the Reservation record of interest, if used where there's a specific reservation we're to be evaluating an expression for (e.g. in a form, report or query). A shorter version of ThisResv()        

 

 

Function:Site        
Result-type:Record        
Arguments:(none)        
Description:Returns the Site record of interest, if used where there's a specific site (or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). A shorter version of ThisSite().        

 

 

Function:This        
Result-type:Record        
Arguments:(none)        
Description:Returns the record of interest, if used where there's a specific record we're to be evaluating an expression for (e.g. in a report or query). Same as ThisRecord().        

 

 

Function:ThisCust        
Result-type:Record        
Arguments:(none)        
Description:Returns the Customer record of interest, if used where there's a specific customer (or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). Same as the Cust() function.        

 

 

Function:ThisCustNumTran        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the number of transactions linked to the given reservation or customer record        

 

 

Function:ThisCustTranAt        
Result-type:Record        
Arguments:nIndex        
Description:Returns the record for the nth transaction linked to the current customer of interest, if used where there's a specific customer (or reservation) we're to be evaluating an expression for (e.g. in a form, report or query)        

 

 

Function:ThisDate        
Result-type:Date/Time        
Arguments:(none)        
Description:Returns the current date of interest, if used where there's a specific date we're to be evaluating an expression for (e.g. in a summary report or color scheme)        

 

 

Function:ThisDlgCtrlLastFocus        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the name of the standard dialog control that last had focus (e.g. lost the focus most recently). If the last control to lose focus was a user-defined control, then the result is 0 (use ThisDlgUserCtrlLastFocus() for user-defined controls).        

 

 

Function:ThisDlgUserCtrlLastFocus        
Result-type:Text        
Arguments:(none)        
Description:Returns the name of the user-defined dialog control that last had focus (e.g. lost the focus most recently). If the last control to lose focus was not a user-defined control, then the result is blank (use ThisDlgCtrlLastFocus() for standard controls).        

 

 

Function:ThisForm        
Result-type:Record        
Arguments:(none)        
Description:Returns the record for the current form, if used inside a form        

 

 

Function:ThisFormHeight        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the full page height of the form or report being printed, if used in a Form or Report definition. The units are in inches, regardless of the form's format. Not defined for character-based forms.        

 

 

Function:ThisFormPosX        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the X position of the current element being printed on a form, if used in a Form definition (0 = left). The position is in inches for any variable-format form, and not defined for character-based forms.        

 

 

Function:ThisFormPosY        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the Y position of the current element being printed on a form, if used in a Form definition (0 = top). The position is in inches for any variable-format form, and not defined for character-based forms.        

 

 

Function:ThisFormSection        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the current section of the form being printed, if used in a Form definition. This is usually the 'page' of the form, if each section requires a single page.        

 

 

Function:ThisFormWidth        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the full page width of the form or report being printed, if used in a Form or Report definition. The units are in inches, regardless of the form's format. Not defined for character-based forms.        

 

 

Function:ThisFromDate        
Result-type:Date/Time        
Arguments:(none)        
Description:Returns the 'From' date of interest, if used where there's a specific date range we're to be evaluating an expression for (e.g. in a list report)        

 

 

Function:ThisFromPeriod        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the 'From' period of interest, if used where there's a specific date and period range we're to be evaluating an expression for (e.g. in a list report)        

 

 

Function:ThisGroupColRec        
Result-type:Record        
Arguments:(none)        
Description:Returns the record of the column grouping, e.g. if used in a Calculated Data Expression for a cross-table query grouping by records of a table        

 

 

Function:ThisGroupColText        
Result-type:Text        
Arguments:(none)        
Description:Returns the text value of the cross-table Column  group of interest, e.g. in a Calculated Data Expression        

 

 

Function:ThisGroupFromDate        
Result-type:Date/Time        
Arguments:(none)        
Description:Returns the starting date of the cross-table reporting group of interest, e.g. in a Grouping Expression for a date-type axis        

 

 

Function:ThisGroupFromPeriod        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the 'From' period of the cross-table reporting group of interest, e.g. in a Grouping Expression for a date/period-type axis        

 

 

Function:ThisGroupRec        
Result-type:Record        
Arguments:(none)        
Description:Returns the record of the current grouping, e.g. if used in a Grouping Expression for a cross-table query grouping by records of a table        

 

 

Function:ThisGroupRowRec        
Result-type:Record        
Arguments:(none)        
Description:Returns the record of the row grouping, e.g. if used in a Calculated Data Expression for a cross-table query grouping by records of a table        

 

 

Function:ThisGroupRowText        
Result-type:Text        
Arguments:(none)        
Description:Returns the text value of the cross-table Row group of interest, e.g. in a Calculated Data Expression        

 

 

Function:ThisGroupText        
Result-type:Text        
Arguments:(none)        
Description:Returns the text value of the cross-table reporting group of interest, e.g. in a Grouping Expression        

 

 

Function:ThisGroupToDate        
Result-type:Date/Time        
Arguments:(none)        
Description:Returns the ending date of the cross-table reporting group of interest, e.g. in a Grouping Expression for a date-type axis        

 

 

Function:ThisGroupToPeriod        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the 'To' period of the cross-table reporting group of interest, e.g. in a Grouping Expression for a date/period-type axis        

 

 

Function:ThisListCount        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the number of records in the list of operating records, if used where a list of records is present (e.g. transactions in a receipt form or Transactions dialog, applicable records for a cell of a cross-tab report)        

 

 

Function:ThisListRec        
Result-type:Record        
Arguments:nIndex        
Description:Returns the Nth record in the list of operating records, if used where a list of records is present (e.g. transactions in a receipt form or Transactions dialog, applicable records for a cell of a cross-tab report)        

 

 

Function:ThisNumPages        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the number of pages in the form or report being printed, if used in a Form or Report definition. This is relative to the current section, e.g. when the list of transactions requires multiple pages for a given section.        

 

 

Function:ThisPage        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the current page number of the form or report being printed, if used in a Form or Report definition. This is relative to the current section, e.g. when the list of transactions requires multiple pages for a given section.        

 

 

Function:ThisPark        
Result-type:Record        
Arguments:(none)        
Description:Returns the Park record of interest, if used where there's a specific park (or site or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). Same as the Park() function.        

 

 

Function:ThisPeriod        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the current period of interest, if used where there's a specific date and period we're to be evaluating an expression for (e.g. for a color scheme)        

 

 

Function:ThisPONotesText        
Result-type:Text        
Arguments:(none)        
Description:Returns the Purchase Order notes text entered in the Print Purchase Orders dialog, if used in Purchase Order type Forms definitions        

 

 

Function:ThisQuery        
Result-type:Record        
Arguments:(none)        
Description:Returns the record for the current query, if used inside a query        

 

 

Function:ThisQueryColumn        
Result-type:Record        
Arguments:(none)        
Description:Returns the record for the current query column, if used inside a query        

 

 

Function:        ThisRate        

Result-type:        Record        

Arguments:        (none)        

Description:        Returns the record for the current Rate. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateMeterDate        

Result-type:        Date        

Arguments:        (none)        

Description:        Returns the 'Reading Date' of a meter reading that the Rate is being calculated for.  This is only used in expressions for calculating the Description, Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateMeterDatePrev        

Result-type:        Date        

Arguments:        (none)        

Description:        Returns the 'Reading Date' of the previous meter reading or a Site that the Rate is being calculated for.  It may not always be valid, e.g. if there is no reading History.  This is only used in expressions for calculating the Description, Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateMeterNew        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the new meter reading that the Rate is being calculated for.  This is only used in expressions for calculating the Description, Each or Qty values in the transactions of Rate definitions. definitions.        

 

 

Function:        ThisRateMeterPrev        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the previous meter reading for the Site that the Rate is being calculated for.  This is only used in expressions for calculating the Description, Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRatePeriods        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the number of periods that the Rate is being calculated for. Note: This is periods in terms of the rate (e.g. it could be periods, days, weeks, months), not necessarily Periods in terms of Schedules. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateQtyExtra        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the extra quantity that the Rate is being calculated for. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateQtyMeter        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the meter reading quantity that the Rate is being calculated for. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateQtyTotal        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the total quantity that the Rate is being calculated for. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:        ThisRateSites        

Result-type:        Numeric        

Arguments:        (none)        

Description:        Returns the number of sites that the Rate is being used for. This is only used in expressions for calculating the Each or Qty values in the transactions of Rate definitions.        

 

 

Function:ThisRecord        
Result-type:Record        
Arguments:(none)        
Description:Returns the record of interest, if used where there's a specific record we're to be evaluating an expression for (e.g. in a report or query). A shorter version is This().        

 

 

Function:ThisResv        
Result-type:Record        
Arguments:(none)        
Description:Returns the Reservation record of interest, if used where there's a specific reservation we're to be evaluating an expression for (e.g. in a form, report or query). Same as the Resv() function.        

 

 

Function:ThisResvNumTran        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the number of transactions linked to the given reservation or customer record        

 

 

Function:ThisResvTranAt        
Result-type:Record        
Arguments:nIndex        
Description:Returns the record for the nth transaction linked to the current reservation of interest, if used where there's a specific reservation we're to be evaluating an expression for (e.g. in a form, report or query)        

 

 

Function:ThisSchedule        
Result-type:Record        
Arguments:(none)        
Description:Returns the record for the current schedule of interest, if used where scheduled periods are applicable. For instance on the Rack view for site/date color schemes, or reservation-based expressions        

 

 

Function:ThisSearchText        
Result-type:Text        
Arguments:(none)        
Description:Returns the current search text of interest, for instance if used in a search query        

 

 

Function:ThisSite        
Result-type:Record        
Arguments:(none)        
Description:Returns the Site record of interest, if used where there's a specific site (or reservation) we're to be evaluating an expression for (e.g. in a form, report or query). Same as the Site() function.        

 

 

Function:ThisTable        
Result-type:Text        
Arguments:(none)        
Description:Returns the name of the table of interest, if used where there's a specific table we're to be evaluating an expression for (e.g. in a report or query)        

 

 

Function:ThisTabView        
Result-type:Text        
Arguments:(none)        
Description:Returns the name of the current Tab View (e.g. 'Arrivals', 'Rack', etc), for instance if used in a Menu expression or add-on Query.  If used in a stand-alone Query (in a ShowQuery dialog, not a Tab View), then it will be the name of the Query.        

 

 

Function:        ThisTempRec        

Result-type:        Record        

Arguments:        (none)        

Description:        Returns the temporary operating record in a Dialog definition, for instance the tentative reservation in a New Reservation dialog which contains the currently selected Preferences information.        

 

 

Function:ThisTextValue        
Result-type:Text        
Arguments:(none)        
Description:Returns the current text value of interest, if used for instance in a formatting expression or special condition        

 

 

Function:ThisToDate        
Result-type:Date/Time        
Arguments:(none)        
Description:Returns the 'To' date of interest, if used where there's a specific date range we're to be evaluating an expression for (e.g. in a list report)        

 

 

Function:ThisToPeriod        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the 'To' period of interest, if used where there's a specific date and period range we're to be evaluating an expression for (e.g. in a list report)        

 

 

Function:ThisTran        
Result-type:Record        
Arguments:(none)        
Description:Returns the Transaction record of interest, if used where there's a specific transaction we're to be evaluating an expression for (e.g. in a transaction report or query ). Same as the Tran() function.        

 

 

Function:ThisValue        
Result-type:Numeric        
Arguments:(none)        
Description:Returns the current value of interest, if used for instance in a formatting expression or special condition (e.g. a color scheme)        

 

 

Function:Tran        
Result-type:Record        
Arguments:(none)        
Description:Returns the Transaction record of interest, if used where there's a specific transaction we're to be evaluating an expression for (e.g. in a transaction report or query ). A shorter version of ThisTran().        

 

 

 

 


Page URL https://CampgroundMaster.com/help/context(this___).html

Campground Master Home