<ADODB_Recordset>.GetString

<< Click to Display Table of Contents >>

Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Methods >

<ADODB_Recordset>.GetString

 

Description

 
Returns the specified ADODB_Recordset as a string.

 

Syntax

 

s = <ADODB_Recordset>.GetString ([lFormat [, nRec [, sColDelim [, sRowDelim [, nullexpr]]]]])

 

Returns

 

String.

 

Parameters

 

Name

Type

Optional

Meaning

lFormat

Number

Yes

A value that specifies the format when retrieving a Recordset as a string

 

Use %adClipString (2) to delimits rows by the sRowDelim parameter, columns by the sColDelim parameter, and null values by the nullexpr parameter

 

nRec

Number

Yes

The number of rows to be converted in the Recordset

sColDelim

String

Yes

If lFormat is set to %adClipString it is a column delimiter. Otherwise it is the tab character

sRowDelim

String

Yes

If lFormat is set to %adClipString it is a row delimiter. Otherwise it is the carriage return character

nullexpr

String

Yes

If lFormat is set to %adClipString it is an expression used instead of a null value. Otherwise it is an empty string

 

Remarks

 

Restrictions

 

See also

 

Examples