RunExport

Syntax

SQL.RunExport ViewOrTableOrQuery [, ExpFileName][, TimeOut]

Description

Opens a VIEW, TABLE or a SELECT query, and exports the data to a TAB-separated text file, where the first line contains the field names.

The output is similar to the output option: "Export to..." in the SQL Designer

Parameter	Description
ViewOrTableOrQuery	A reference to a View, Table or Select query.
ExpFileName	Optional. Path and file name of the export file to be created. If omitted, a dialog box appears.
TimeOut	Optional. Specifies the maximum wait time in seconds for the query. If the result does not appear within the specified time, the query is aborted and an error message is generated. Default value: 30 seconds.

See Also

other SQL.Runxxxxxxxx methodes, Exporteren naar....

Example

Sub Main()
 
    Dim sQuery As String
    Dim sFile As String
 
    sQuery = InputBox$("Select Query:")
    sFile = InputBox$("File naam:")
    SQL.RunExport sQuery, sFile
 
End Sub