PublicShow sourceodbc.pl

Sourceodbc_current_connection(?Conn, ?DSN) is nondet
True if Conn is an open ODBC connection to DSN.
Sourceodbc_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.
Sourceodbc_query(+Connection, +SQL, -Row)
Run query without options.
Sourceodbc_query(+Connection, +SQL)
Execute SQL-statement that does not produce a result
Sourceodbc_current_table(-Table, -Facet)
Enumerate the existing tables.
Sourceodbc_table_column(+Connection, +Table, +Column) is semidet
odbc_table_column(+Connection, +Table, -Column) is nondet
True if Column appears in Table on Connection.
Sourceodbc_table_column(+Connection, +Table, ?Column, -Facet)
Sourceodbc_type(+Connection, +TypeSpec, ?Facet)
Sourceodbc_data_source(?DSN, ?Description)
Enumerate the available data-sources
Sourceodbc_table_primary_key(+Connection, +Table, ?Column)
Enumerate columns in primary key for table
Sourceodbc_table_foreign_key(+Connection, ?PkTable, ?PkCol, ?FkTable, ?FkCol)
Enumerate foreign keys columns

Undocumented predicates

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

Sourceodbc_get_connection(Arg1, Arg2)
Sourceodbc_statistics(Arg1)
Sourceodbc_free_statement(Arg1)
Sourceodbc_execute(Arg1, Arg2, Arg3)
Sourceodbc_end_transaction(Arg1, Arg2)
Sourceodbc_disconnect(Arg1)
Sourceodbc_fetch(Arg1, Arg2, Arg3)
Sourceodbc_prepare(Arg1, Arg2, Arg3, Arg4)
Sourceodbc_current_table(Arg1, Arg2, Arg3)
Sourceodbc_close_statement(Arg1)
Sourceodbc_query(Arg1, Arg2, Arg3, Arg4)
Sourceodbc_prepare(Arg1, Arg2, Arg3, Arg4, Arg5)
Sourceodbc_set_connection(Arg1, Arg2)
Sourceodbc_connect(Arg1, Arg2, Arg3)
Sourceodbc_debug(Arg1)
Sourceodbc_clone_statement(Arg1, Arg2)
Sourceodbc_execute(Arg1, Arg2)