<< 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