Syntax |
SQLRetrieveToFile(ID,destination$ [,[isColumnNames] [,delimiter$]]) |
|
Description |
Retrieves the results of a query and writes them to the specified file. |
|
Comments |
The following table describes the parameters to the SQLRetrieveToFile function: |
|
|
Parameter |
Description |
|
ID |
Long specifying a valid connection ID. |
|
destination |
String specifying the file where the results are written. |
|
isColumnNames |
Optional Boolean specifying whether the first row of results returned are the bound column names. By default, the column names are not returned. |
|
delimiter |
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. |
|
Example |
This example opens a connection, runs a query, binds columns, and writes the results to a file. Sub Main() |
|
See Also |
SQLOpen (function); SQLExecQuery (function); SQLClose (function); SQLBind (function); SQLRetrieve (function). |
S |