🚀 go-pugleaf

Use ADO recordset GetString method. Recordset is available from
TADODataSet.Recordset. Below there is description from MSDN:

GetString Method
Returns the Recordset as a string.

Syntax
Variant = recordset.GetString(StringFormat, NumRows, ColumnDelimiter,
RowDelimiter, NullExpr)Return Value
Returns the Recordset as a string-valued Variant (BSTR).

Parameters
  StringFormat
  A StringFormatEnum value that specifies how the Recordset should be
converted to a string. The RowDelimiter, ColumnDelimiter, and NullExpr
parameters are used only with a StringFormat of adClipString.
  NumRows
  Optional. The number of rows to be converted in the Recordset. If NumRows
is not specified, or if it is greater than the total number of rows in the
Recordset, then all the rows in the Recordset are converted.
  ColumnDelimiter
  Optional. A delimiter used between columns, if specified, otherwise the
TAB character.
  RowDelimiter
  Optional. A delimiter used between rows, if specified, otherwise the
CARRIAGE RETURN character.
  NullExpr
  Optional. An expression used in place of a null value, if specified,
otherwise the empty string.
Remarks
Row data, but no schema data, is saved to the string. Therefore, a Recordset
cannot be reopened using this string.

This method is equivalent to the RDO GetClipString method.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Ronan" <bhuvan.sharma@uwe.ac.uk> �������/�������� � �������� ���������:
news:3fbe214e@newsgroups.borland.com...
> Hi,
>
>  I am trying to copy all the values in a ADODataSet's colums to a .txt
file.
> Kindly help me how to do that.
>  Or if there is a direct way to do so, bypassing the requirement of
DataSet
> then please do tell.
>
> Many thanks,
> Ronan
>
>
>