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:   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 http://CampgroundMaster.com/shelp/context(this___).html

Campground Master Home