DBSetQueryAction(String, String, Range, 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 DBSetQueryAction(
	string callID,
	string Query,
	Range targetRange,
	string ConnString,
	Range caller,
	string targetRangeName
	)

callID: Type: String
the key for the statusMsg container
Query: Type: String
query for getting data
targetRange: Type: Range
Range with Object beneath to put the Query/ConnString into
ConnString: Type: String
connection string defining DB, user, etc...
caller: Type: Range
calling range passed by Action procedure
targetRangeName: Type: String