Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > VB Language Reference > SQLRetrieveToFile FunctionThis custom VB function fetches the results of a pending query on the connection specified by connection and stores them in the file specified by destination. NOTE: Siebel VB SQLxxxx functions are supported for non-Unicode databases only. SyntaxSQLRetrieveToFile(connection, destination[, columnNames][, columnDelimiter])
ReturnsIf successful, a variant containing the number of rows in the result set; if unsuccessful, -1. UsageThe arguments must be named arguments. For information about named arguments, read Named Arguments and Call Statement. CAUTION: This function, as well as the other SQL functions available in Siebel VB, should not be used to query the underlying database. Use the Siebel Object Interfaces to query Siebel data. Use the SQL functions only to query non-Siebel data. ExampleThis example opens a connection to a data source and retrieves information to a file. Sub Button_Click Dim connection As Long connection = SQLOpen("DSN = SblTest",outputStr,prompt: = 3) query = "select * from customer" filename = "c:\myfile.txt" retcode = SQLClose(connection) See AlsoSQLClose Function |
Siebel VB Language Reference |