SQLRetrieveToFile (function)


SQLRetrieveToFile(ID,destination$ [,[isColumnNames] [,delimiter$]])


Retrieves the results of a query and writes them to the specified file.


The following table describes the parameters to the SQLRetrieveToFile function:






Long specifying a valid connection ID.



String specifying the file where the results are written.



Optional Boolean specifying whether the first row of results returned are the bound column names. By default, the column names are not returned.



Optional String specifying the column separator. A tab (Chr$(9)) is used as the default.


Before you can retrieve the results from a query, you must (1) initiate a query by calling the SQLExecQuery function and (2) specify the fields to retrieve by calling the SQLBind function.

This function returns the number of rows written to the file. A runtime error is generated if there are no pending results or if the Basic Control Engine is unable to open the specified file.

The Basic Control Engine generates a runtime error if SQLRetrieveToFile fails. Additional error information may be placed in memory for later use with the SQLError function.


This example opens a connection, runs a query, binds columns, and writes the results to a file.

Sub Main()
  Dim b() As Variant
  id& = SQLOpen("DSN=SAMPLE;UID=RICH",,4)
  t& = SQLExecQuery(id&,"Select * From c:\sample.dbf")
  i% = SQLBind(id&,b,3)
  i% = SQLBind(id&,b,1)
  i% = SQLBind(id&,b,2)
  i% = SQLBind(id&,b,6)
  l& = SQLRetrieveToFile(id&,"c:\results.txt",True,",")
  id& = SQLClose(id&)
End Sub

See Also

SQLOpen (function); SQLExecQuery (function); SQLClose (function); SQLBind (function); SQLRetrieve (function).

More information