PrologSQL Documentation.

This page is under construction

• db_open/3, odbc_open/3 (+DataBase, +UserName, +Password)
Open a database.


• db_close/0, odbc_close/0
Close a database.


• db_flag/3 (+/-Flag, -Old, +New)
Setting DB flags, Possible values are:
• (fail_on_error, on, off)
• (fail_on_error, off, on)
• (show_query, off, on)
• (show_query, on, off)


• db_query/2, odbc_query/2 (+Head, +Body)
Create a query to a database (Head - interface, Body - description.)


• db_import/2, odbc_import/2 (+DbTable, +SymName)
Link a table DbTable with predicate SymName


• db_transaction/1, odbc_transaction/1 (+Type)
Transaction processing. Where Type is commit or rollback


• db_sql/1, odbc_sql/1 (Sql)
Connect to an SQL (non-query)


• db_sql_select/2, odbc_sql_select/2 (+Select, -Rows)
Connect to an SQL (query)


• db_delete/2, odbc_delete/2 (+Head, +Body)
Declare deletion predicate.


• db_insert/2, odbc_insert/2 (+Head, +Body)
Declare insertion predicade.


• db_show_schema/1 (+Content)
Where Content is:
• tuples(Table) - Shows the contents of the base table named Table
• user - Shows just those tables that belongs to you
• accessible - Shows all accessible table names for the user
• arity(Table) - The number of fields in the table Table
• columns(Table) - The fild names of a table
• db_get_schema/2 (+Content, -List)
• db_attach/2, odbc_attach/2
• db_record/2
• db_create_table/2
• db_create_index/3
• db_delete_table/1
• db_delete_view/1
• db_delete_index/1
• db_add_record/2
• delete_record/2