Options

There are a number of options that can be given to SQLExecute, SQLCreateTable, SQLDropTable, SQLInsert, SQLDelete, SQLSelect, and SQLUpdate. If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package.

Options of SQLExecute.

Here is an example of these options. This loads DatabaseLink and connects to the demo database.

In[1]:=

The option GetAsStrings can retrieve data without converting it to a Mathematica type. This can be used with SQLExecute and SQLSelect.

In[3]:=

The option MaxRows can limit the number of rows returned. This can be used with SQLExecute and SQLSelect.

In[4]:=

Out[4]=

The option ShowColumnHeadings can be used to limit the number of rows returned. This can be used with SQLExecute and SQLSelect.

The option ShowColumnHeadings can retrieve the column headings with the results. This can be used with SQLExecute and SQLSelect.

In[5]:=

The option Timeout can be used to cancel a query if it takes too long to execute. SQLExecute, SQLCreateTable, SQLDropTable, SQLInsert, SQLDelete, SQLSelect, and SQLUpdate can each use the Timeout option.

This closes the connection.

In[6]:=