GetColumnString Method

SQL-DMO

SQL-DMO

GetColumnString Method

The GetColumnString method returns a QueryResults object result set member converted to a String value.

Applies To
QueryResults Object
Syntax

object.GetColumnString( Row , Column ) as String

Parts

object

Expression that evaluates to an object in the Applies To list

Row

Long integer that identifies a row by ordinal position

Column

Long integer that identifies a column by ordinal position

Prototype (C/C++)

HRESULT GetColumnString(
long lRow,
long lCol,
SQLDMO_LPBSTR pRetVal);

Note  SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Returns

A String representation of the value of a QueryResults result set member

Remarks

When converting a value of any data type to string, conversion rules are those applied for the locale of the client workstation.

The Row and Column Parameters are 1-based in Visual Basic applications, and are zero-based in C++ applications.