Codebase list swi-prolog / 109af2a1-1aa9-45ee-9e2f-3bf3c7edfa79/main packages / odbc
109af2a1-1aa9-45ee-9e2f-3bf3c7edfa79/main

Tree @109af2a1-1aa9-45ee-9e2f-3bf3c7edfa79/main (Download .tar.gz) 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
			SWI-Prolog ODBC interface

I once thought Prolog was poorly standardised,   but  now I know better.
SQL is very poorly standardised.

Microsoft SQL Server
====================

    * If you want to use the option source(true) to get the table-name
      in the result-set, you must use add 'FOR BROWSE' at the end of the
      SQL SELECT statement.  Read more in

	http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_9qp1.asp

    * To allow multiple active statements, use

	odbc_set_connection(Connection, cursor_type(dynamic))

History of packages / odbc @109af2a1-1aa9-45ee-9e2f-3bf3c7edfa79/main