odbc_current_connection(?Conn, ?DSN) is nondet

True if Conn is an open ODBC connection to DSN.

 odbc_driver_connect(+DriverString, -Connection, +Options) is det

Connects to a database using SQLDriverConnect(). This API allows for driver-specific additional options. DriverString is passed without checking. Options should not include user and password.

Whenever possible, applications should use odbc_connect/3. If you need this predicate, please check the documentation for SQLDriverConnect() and the documentation of your driver.

To be done

- Add facilities to deal with prompted completion of the driver options.

 odbc_query(+Connection, +SQL, -Row)

Run query without options.

 odbc_query(+Connection, +SQL)

Execute SQL-statement that does not produce a result

 odbc_current_table(-Table, -Facet)

Enumerate the existing tables.

 odbc_table_column(+Connection, +Table, +Column) is semidet

odbc_table_column(+Connection, +Table, -Column) is nondet

True if Column appears in Table on Connection.

 odbc_table_column(+Connection, +Table, ?Column, -Facet)

 sql_type(+TypeName, +Row, -Type)[private]

Create a canonical Prolog representation for the type. This is very incomplete code.

 odbc_type(+Connection, +TypeSpec, ?Facet)

 odbc_data_source(?DSN, ?Description)

Enumerate the available data-sources

 odbc_table_primary_key(+Connection, +Table, ?Column)

Enumerate columns in primary key for table

 odbc_table_foreign_key(+Connection, ?PkTable, ?PkCol, ?FkTable, ?FkCol)

Enumerate foreign keys columns

Undocumented predicates

The following predicates are exported, but not or incorrectly documented.

 odbc_statistics(Arg1)

 odbc_current_table(Arg1, Arg2, Arg3)

 odbc_next_result_set(Arg1)

 odbc_query(Arg1, Arg2, Arg3, Arg4)

 odbc_prepare(Arg1, Arg2, Arg3, Arg4, Arg5)

 odbc_disconnect(Arg1)

 odbc_debug(Arg1)

 odbc_free_statement(Arg1)

 odbc_fetch(Arg1, Arg2, Arg3)

 odbc_end_transaction(Arg1, Arg2)

 odbc_prepare(Arg1, Arg2, Arg3, Arg4)

 odbc_cancel_thread(Arg1)

 odbc_clone_statement(Arg1, Arg2)

 odbc_execute(Arg1, Arg2, Arg3)

 odbc_get_connection(Arg1, Arg2)

 odbc_connect(Arg1, Arg2, Arg3)

 odbc_set_option(Arg1)

 odbc_close_statement(Arg1)

 odbc_execute(Arg1, Arg2)

 odbc_set_connection(Arg1, Arg2)