DBSetPowerQueryAction(String, String, Range, String) Method

set Query parameters (query text and connection string) of Query List or pivot table (incl. chart)
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public static void DBSetPowerQueryAction(
	string callID,
	string Query,
	Range caller,
	string queryName
	)

Parameters

callID
Type: String
the key for the statusMsg container
Query
Type: String
(power) query for getting data
caller
Type: Range
calling range passed by Action procedure
queryName
Type: String
Name of Powerquery where query should be set