Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > Methods Reference for Siebel VB > ODBC Methods > ODBC Run Query MethodThe ODBC Run Query method is a Siebel VB method that runs an SQL statement on a connection that the ODBC Open method establishes. It returns the number of columns in the result set for SQL SELECT statements as a variant. The value that it returns depends which of the following statements you use:
If it cannot run the query on the data source, or if the connection is not valid, then it returns a negative error code. If there are any pending results on the connection, then it replaces the pending results with the new results. FormatSQLExecQuery(connection, query) The following table describes the arguments that you can use with this method. ExampleThe following example performs a query on the data source: Sub Button_Click ' Run the query retcode = SQLRetrieve(connection: = connection, _ ' Get the next 50 rows of from the result set |
Siebel VB Language Reference | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |