User Tools

  • Vistasource Document Library

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
rtw_4.5:rtw_functions [2012/08/30 21:43]
cjaeger [RTW Functions]
rtw_4.5:rtw_functions [2018/08/04 20:09] (current)
Line 10: Line 10:
  
 In versions prior to Microsoft(r) Excel(r) 2007, select **Insert -> Function** on the Microsoft® Excel menu bar to display the Insert Function dialog box. Select the Vistasource RTW category to display the RTW functions. The functions are listed in alphabetical order: In versions prior to Microsoft(r) Excel(r) 2007, select **Insert -> Function** on the Microsoft® Excel menu bar to display the Insert Function dialog box. Select the Vistasource RTW category to display the RTW functions. The functions are listed in alphabetical order:
- 
-  *[[rtw_functions#​PACKAGE_DATA]] 
-  *[[rtw_functions#​PARSE_BULK]] 
-  *[[rtw_functions#​PARSE_DATA]] 
-  *[[rtw_functions#​RTINSERT]] 
-  *[[rtw_functions#​rtinsert_engine-specific|RTINSERT_RFA]] 
-  *[[rtw_functions#​rtinsert_engine-specific|RTINSERT_SFC]] 
-  *[[rtw_functions#​rtinsert_engine-specific|RTINSERT_RTSHARE]] 
-  *[[rtw_functions#​RTS]] 
-  *[[rtw_functions#​rts_engine-specific|RTS_BLOOM]] 
-  *[[rtw_functions#​rts_engine-specific|RTS_DEMO]] 
-  *[[rtw_functions#​rts_engine-specific|RTS_NF]] 
-  *[[rtw_functions#​rts_engine-specific|RTS_RFA]] 
-  *[[rtw4.5:​Working_with_rtshare#​rtw_functions|RTS_SHARE]] 
-  *[[rtw_functions#​rts_engine-specific|RTS_SFC] 
-  *[[rtw_functions#​rts_engine-specific|RTS_WEB]] 
  
    
 +  *[[rtw_4.5:​rtw_functions#​PACKAGE_DATA]]
 +  *[[rtw_4.5:​rtw_functions#​PARSE_BULK]]
 +  *[[rtw_4.5:​rtw_functions#​PARSE_DATA]]
 +  *[[rtw_4.5:​rtw_functions#​RTINSERT]]
 +  *[[rtw_4.5:​rtw_functions#​rtinsert_engine-specific|RTINSERT_RFA]]
 +  *[[rtw_4.5:​rtw_functions#​rtinsert_engine-specific|RTINSERT_SFC]]
 +  * **[[rtw_4.5:​rtshare_operation#​wrapper_functions|RTINSERT_SHARE]]**
 +  *[[rtw_4.5:​rtw_functions#​RTS]]
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_BLOOM]]
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_DEMO]]
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_NF]]
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_RFA]]
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_SFC]]
 +  * **[[rtw_4.5:​rtshare_operation#​wrapper_functions|RTS_SHARE]]**
 +  *[[rtw_4.5:​rtw_functions#​rts_engine-specific|RTS_WEB]]
  
-  
  
 +
 + 
 ===== RTS and RTINSERT ===== ===== RTS and RTINSERT =====
  
Line 36: Line 36:
    
  
 +<​note>​ If using RTSHARE, go to [[rtw_4.5:​rtshare_operation#​RTSHARE Functions]].</​note>​
 ===== RTS ===== ===== RTS =====
  
Line 86: Line 86:
   =RTINSERT(C15,"​vsRMDS2","​DTS",​ "​MYREC",​ "​BID"​)   =RTINSERT(C15,"​vsRMDS2","​DTS",​ "​MYREC",​ "​BID"​)
  
 +<​note>​When inserting values with RTINSERT, the output cell may show an initial #N/A, This is intrinsic to how an RTD server works, data is not dropped. As soon as the actual value is available, OK is displayed, indicating that the insert was successful. For more information see:  
 +[[http://​msdn.microsoft.com/​en-us/​library/​aa140060(v=office.10).aspx#​odc_xlrtdfaq_whyalwaysna|msdn.microsoft.com]]</​note> ​
 ===== RTINSERT (Engine-Specific) ===== ===== RTINSERT (Engine-Specific) =====
  
Line 101: Line 102:
   =RTINSERT_RFA (C15, "​DTS",​ "​MYREC",​ "​BID"​)   =RTINSERT_RFA (C15, "​DTS",​ "​MYREC",​ "​BID"​)
  
- + <​note>​When inserting values with RTINSERT_RFA or RTINSERT_SFC,​ respectively,​ the output cell may show an initial #N/A, This is intrinsic to how an RTD server works, data is not dropped. As soon as the actual value is available, OK is displayed, indicating that the insert was successful. For more information see: [[http://​msdn.microsoft.com/​en-us/​library/​aa140060(v=office.10).aspx#​odc_xlrtdfaq_whyalwaysna|msdn.microsoft.com]] </​note> ​
 ===== PARSE_DATA ===== ===== PARSE_DATA =====