From c8f303cd304e8fc08c726a03b95d51e998cd21bb Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Tue, 30 Nov 2010 21:03:08 +0000
Subject: Support binding null to an SQL command parameter Bind null for
 missing values for SQL merge data

---
 libodbcpp/command.h |  2 ++
 libodbcpp/param.cpp |  6 ++++++
 libodbcpp/param.h   | 10 ++++++++++
 3 files changed, 18 insertions(+)

diff --git a/libodbcpp/command.h b/libodbcpp/command.h
index 0517afd..1bc9f6d 100644
--- a/libodbcpp/command.h
+++ b/libodbcpp/command.h
@@ -29,6 +29,8 @@ namespace ODBC {
 			void				bindParamT(unsigned int i, const SQL_TIMESTAMP_STRUCT &);
 			void				bindParamT(unsigned int i, time_t);
 
+			void				bindNull(unsigned int i);
+
 			const std::string	sql;
 		protected:
 			friend class Param;
diff --git a/libodbcpp/param.cpp b/libodbcpp/param.cpp
index 9ccb7c9..91fc9e8 100644
--- a/libodbcpp/param.cpp
+++ b/libodbcpp/param.cpp
@@ -79,6 +79,12 @@ SIMPLEBINDER(const struct tm *, TimeStampParam, T);
 SIMPLEBINDER(const SQL_TIMESTAMP_STRUCT &, TimeStampParam, T);
 SIMPLEBINDER(time_t, TimeStampParam, T);
 
+void
+ODBC::Command::bindNull(unsigned int i)
+{
+	makeParam<NullParam>(i)->bind();
+}
+
 void
 ODBC::GlibUstringParam::operator=(Glib::ustring const & d)
 {
diff --git a/libodbcpp/param.h b/libodbcpp/param.h
index f845a49..0009956 100644
--- a/libodbcpp/param.h
+++ b/libodbcpp/param.h
@@ -94,6 +94,16 @@ namespace ODBC {
 		protected:
 			SQL_TIMESTAMP_STRUCT data;
 	};
+	class NullParam : public Param {
+		public:
+			NullParam() : Param() { }
+			NullParam(Command * c, unsigned int i) : Param(c, i) { bindLen = SQL_NULL_DATA; }
+			virtual SQLSMALLINT ctype() const { return SQL_C_LONG; }
+			virtual SQLSMALLINT stype() const { return SQL_C_LONG; }
+			virtual SQLINTEGER size() const { return 0; }
+			virtual SQLINTEGER dp() const { return 0; }
+			virtual const void * dataAddress() const { return NULL; }
+	};
 }
 
 #endif
-- 
cgit v1.2.3