- 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)
- 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_connect(Arg1, Arg2, Arg3)
- odbc_statistics(Arg1)
- odbc_debug(Arg1)
- odbc_cancel_thread(Arg1)
- odbc_current_table(Arg1, Arg2, Arg3)
- odbc_close_statement(Arg1)
- odbc_clone_statement(Arg1, Arg2)
- odbc_free_statement(Arg1)
- odbc_fetch(Arg1, Arg2, Arg3)
- odbc_set_option(Arg1)
- odbc_prepare(Arg1, Arg2, Arg3, Arg4)
- odbc_prepare(Arg1, Arg2, Arg3, Arg4, Arg5)
- odbc_execute(Arg1, Arg2)
- odbc_execute(Arg1, Arg2, Arg3)
- odbc_end_transaction(Arg1, Arg2)
- odbc_get_connection(Arg1, Arg2)
- odbc_set_connection(Arg1, Arg2)
- odbc_next_result_set(Arg1)
- odbc_disconnect(Arg1)
- odbc_query(Arg1, Arg2, Arg3, Arg4)