Skip to Content.
Sympa Menu

freetds - PATCH - few more SQL info handlers

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Alex Hornby <alex AT anvil.co.uk>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: PATCH - few more SQL info handlers
  • Date: 06 Nov 2002 12:14:08 +0000


Hi,

Here are few more stubbed out handlers - unixODBC seems to substitute in
sensible values for the empty strings.

I also changed info to report only DML as being available in
transactions. I think this is correct, as I'd be surprised if sybase or
sql server could roll back a create table statement!

Cheers,
Alex.

Index: src/odbc/odbc.c
===================================================================
RCS file: /cvsroot/freetds/freetds/src/odbc/odbc.c,v
retrieving revision 1.82
diff -u -r1.82 odbc.c
--- src/odbc/odbc.c 4 Nov 2002 19:49:19 -0000 1.82
+++ src/odbc/odbc.c 6 Nov 2002 12:04:28 -0000
@@ -2252,12 +2252,32 @@
*uiInfoValue = SQL_SCCO_READ_ONLY;
break;
case SQL_TXN_CAPABLE:
- /* transaction for DML and DDL */
- *siInfoValue = SQL_TC_ALL;
+ /* transaction for DML only */
+ *siInfoValue = SQL_TC_DML;
break;
case SQL_DEFAULT_TXN_ISOLATION:
*uiInfoValue = SQL_TXN_READ_COMMITTED;
break;
+ case SQL_TXN_ISOLATION_OPTION:
+ *uiInfoValue = (SQL_TXN_READ_UNCOMMITTED |
+ SQL_TXN_READ_COMMITTED | SQL_TXN_REPEATABLE_READ |
+ SQL_TXN_SERIALIZABLE);
+ break;
+ case SQL_KEYWORDS:
+ rgbInfoValue = "";
+ break;
+ case SQL_NUMERIC_FUNCTIONS:
+ rgbInfoValue = "";
+ break;
+ case SQL_TIMEDATE_FUNCTIONS:
+ rgbInfoValue = "";
+ break;
+ case SQL_STRING_FUNCTIONS:
+ rgbInfoValue = "";
+ break;
+ case SQL_SYSTEM_FUNCTIONS:
+ rgbInfoValue = "";
+ break;
/* TODO support for other options */
default:
/* error HYC00*/







Archive powered by MHonArc 2.6.24.

Top of Page