Follow-On Topics

Related Topics

# Using SQL Free Type Mode

Selecting the SQL Free Type button in the toolbar displays the SQL tab in the dialog box . This provides two option radio buttons as described below for selecting the query type that you wish to use. The Database Query (OLEDB) Tool supports two modes of query in free-type mode.
|  | Execute Command — This executes the specified SQL statement and retrieve the corresponding rowset. This mode is only supported by OLEDB Providers that can performed SQL-based queries.
|  | Open Table / Object — This mode allow rowsets to be retrieved from OLEDB Providers that do not support creating rowsets through commands. It allows consumers to open and work directly with individual tables or indexes in a data store, generating a rowset of all rows in the table or index. In this mode, instead of specifying a SQL Statement to execute, the identifier for the table or index that is to be queried is entered. Open Table / Object mode is supported by all OLEDB Providers.
| Click the image to view full size.

Copyright © 2018 Quadrant Software B.V. All rights reserved.