Additional Functions
      Back to home
      1. Weatherford Knowledge Base
      2. P#
      3. Additional Functions

      RefTableKey()

      Returns the key for specified exact, interpolated or extremum value of the specified reference table for specified entity and specified time stamp option for specified value column.

      Syntax

      RefTableKey(
           refTable as a string, 
           valueOrExtremum as a string, 
           UnitName as a string, 
           ColumnName as a string, 
           UnitName as a string, 
           EntityName as a string, 
           TimeStampOption as a string
      )

      Examples


      RefTableKey("reference table", "33.3", "Pa", "RefValue", "m", "Well L", "Current")

      RefTableKey("reference table", "Max", "Pa", "RefValue", "m", "Well L", "Last")

      RefTableKey("reference table", "Min", "Pa", "RefValue", "m", "Well K", "None")

      Examples


      RefTableKey("reference table", "33.3", "Pa", "RefValue", "m", "Well K", #04/25/2007#)

      RefTableKey("reference table", "Min", "Pa", "RefValue", "m", "Well K", #04/25/2007#)