![Click to include private Public](/help/source/res/public.png)
odbc.pl
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
andpassword
.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.
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_get_connection(Arg1, Arg2)
odbc_statistics(Arg1)
odbc_free_statement(Arg1)
odbc_execute(Arg1, Arg2, Arg3)
odbc_end_transaction(Arg1, Arg2)
odbc_disconnect(Arg1)
odbc_fetch(Arg1, Arg2, Arg3)
odbc_prepare(Arg1, Arg2, Arg3, Arg4)
odbc_current_table(Arg1, Arg2, Arg3)
odbc_close_statement(Arg1)
odbc_query(Arg1, Arg2, Arg3, Arg4)
odbc_prepare(Arg1, Arg2, Arg3, Arg4, Arg5)
odbc_set_connection(Arg1, Arg2)
odbc_connect(Arg1, Arg2, Arg3)
odbc_debug(Arg1)
odbc_clone_statement(Arg1, Arg2)
odbc_execute(Arg1, Arg2)