DBListFetch(Object, Object, Object, Object, Int32, Object, Object, Object, Object) Method

Fetches a list of data defined by query into TargetRange. Optionally copy formulas contained in FormulaRange, extend list depending on ExtendDataArea (0(default) = overwrite, 1=insert Cells, 2=insert Rows) and add field headers if HeaderInfo = TRUE

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public static string DBListFetch(
	object Query,
	object ConnString,
	object targetRange,
	object formulaRange,
	int extendDataArea,
	object HeaderInfo,
	object AutoFit,
	object autoformat,
	object ShowRowNums
	)

Parameters

Query: Type: Object
query for getting data
ConnString: Type: Object
connection string defining DB, user, etc...
targetRange: Type: Object
Range to put the data into
formulaRange: Type: Object
Range to copy formulas down from
extendDataArea: Type: Int32
how to deal with extending List Area
HeaderInfo: Type: Object
should headers be included in list
AutoFit: Type: Object
should columns be auto fitted ?
autoformat: Type: Object
should 1st row formats be auto filled down?
ShowRowNums: Type: Object
should row numbers be displayed in 1st column?

Returns

String

Status Message, data values are returned outside of function cell (@see DBFuncEventHandler)