SQLResultSetCurrent (DatabaseLink Symbol)

SQLResultSetCurrent[rs] reads the current row from a result set.

SQLResultSetPosition (DatabaseLink Symbol)

SQLResultSetPosition[rs] returns an integer that specifies the current position in a result set.

SQLResultSetRead (DatabaseLink Symbol)

SQLResultSetRead[rs] shifts the current position and then reads a row from a result set.SQLResultSetRead[rs, num] reads num rows from a result set.

SQLResultSetTake (DatabaseLink Symbol)

SQLResultSetTake[rs, {m, n}] reads rows m through n from a result set.

SQLStringMatchQ (DatabaseLink Symbol)

SQLStringMatchQ[col, patt] specifies a condition in an SQL query used to test whether the value of a column matches a pattern. The actual format for the pattern varies from ...

SQLUpdate (DatabaseLink Symbol)

SQLUpdate[conn, table, cols, data] updates data in a table in an SQL connection.

Comparing Mathematica-Style Queries and ... (DatabaseLink Tutorial)

DatabaseLink provides two styles of commands for working with data: one for those who are familiar with Mathematica and the other for those who are familiar with SQL. ...

Data Type Mapping (DatabaseLink Tutorial)

One of the most important issues for using a database is the conversion of data as it is stored and retrieved from a database. This tutorial will discuss how Mathematica ...

Schema and Catalogs (DatabaseLink Tutorial)

Database schema and catalogs can be used to hold collections of database components and objects suitable for particular users. They can be particularly useful when working ...

LoadCOMTypeLibrary (NETLink Symbol)

LoadCOMTypeLibrary[library] creates a so-called "interop" assembly from the named type library and loads that assembly.