Windward Engine API Reference
substituteVariables(String[],Object[],String,List<VarResults>) Method
See Also  Send comments on this topic.
WindwardReportsDrivers.net.windward.datasource.odata Namespace > ODataQueryHelper Class > substituteVariables Method : substituteVariables(String[],Object[],String,List<VarResults>) Method




queryParts
The query string broken up into parts such that between each element, an element of toInsert is inserted(possibly with formatting).
toInsert
querytext
parameters

Glossary Item Box

Called by the AbstractDataSource to substitute values into a select statement. Given select: SELECT ${var1} FROM Accounts WHERE Name = ${var2} we create the query parts array: ["SELECT ", " FROM Accounts WHERE Name = ", ""] and the toInsert array: ["Id", "Frank"] This function then returns: SELECT Id FROM Accounts WHERE name = 'Frank'

Syntax

Visual Basic (Declaration) 
Public Overloads Function substituteVariables( _
   ByVal queryParts() As String, _
   ByVal toInsert() As Object, _
   ByVal querytext As String, _
   ByVal parameters As List(Of VarResults) _
) As String
Visual Basic (Usage)Copy Code
Dim instance As ODataQueryHelper
Dim queryParts() As String
Dim toInsert() As Object
Dim querytext As String
Dim parameters As List(Of VarResults)
Dim value As String
 
value = instance.substituteVariables(queryParts, toInsert, querytext, parameters)
C# 
public string substituteVariables( 
   string[] queryParts,
   object[] toInsert,
   string querytext,
   List<VarResults> parameters
)
Managed Extensions for C++ 
public: string* substituteVariables( 
   string*[]* queryParts,
   Object*[]* toInsert,
   string* querytext,
   List<VarResults*>* parameters
)
C++/CLI 
public:
String^ substituteVariables( 
   array<String^>^ queryParts,
   array<Object^>^ toInsert,
   String^ querytext,
   List<VarResults^>^ parameters
)

Parameters

queryParts
The query string broken up into parts such that between each element, an element of toInsert is inserted(possibly with formatting).
toInsert
querytext
parameters

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP, Windows Vista, Windows Server 2003 family

See Also

© 2019 All Rights Reserved.