[Adapdev-commits] Adapdev/src/Adapdev.Data/Sql IInsertQuery.cs,1.5,1.6 IUpdateQuery.cs,1.5,1.6 InsertQuery.cs,1.6,1.7 UpdateQuery.cs,1.6,1.7

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15765/src/Adapdev.Data/Sql

Modified Files:
	IInsertQuery.cs IUpdateQuery.cs InsertQuery.cs UpdateQuery.cs 
Log Message:


Index: InsertQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/InsertQuery.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** InsertQuery.cs	30 Dec 2005 20:42:11 -0000	1.6
--- InsertQuery.cs	12 Jan 2006 05:42:34 -0000	1.7
***************
*** 1,2 ****
--- 1,4 ----
+ using System;
+ 
  namespace Adapdev.Data.Sql
  {
***************
*** 42,45 ****
--- 44,54 ----
  		}
  
+ 		public void AddNull(string columnName)
+ 		{
+ 			cnames[cindex] = columnName;
+ 			cvalues[cindex] = "NULL";
+ 			cindex++;
+ 		}
+ 
  		public void Add(string columnName, object columnValue)
  		{

Index: IInsertQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/IInsertQuery.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** IInsertQuery.cs	16 Nov 2005 07:01:48 -0000	1.5
--- IInsertQuery.cs	12 Jan 2006 05:42:34 -0000	1.6
***************
*** 14,21 ****
  		void Add(string columnName);
  		/// <summary>
! 		/// Adds the column name and value to the insert query
  		/// </summary>
! 		/// <param name="columnName"></param>
! 		/// <param name="columnValue"></param>
  		void Add(string columnName, object columnValue);
  	}
--- 14,21 ----
  		void Add(string columnName);
  		/// <summary>
! 		/// Adds the specified column with a NULL value
  		/// </summary>
! 		/// <param name="columnName">The name of the column</param>
! 		void AddNull(string columnName);
  		void Add(string columnName, object columnValue);
  	}

Index: UpdateQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/UpdateQuery.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** UpdateQuery.cs	30 Dec 2005 20:42:11 -0000	1.6
--- UpdateQuery.cs	12 Jan 2006 05:42:34 -0000	1.7
***************
*** 36,39 ****
--- 36,44 ----
  		}
  
+ 		public void AddNull(string columnName)
+ 		{
+ 			sb.Append(" " + QueryHelper.GetPreDelimeter(this.type) + columnName + QueryHelper.GetPostDelimeter(this.type) + " = NULL,");
+ 		}
+ 
  		public void Add(string columnName, object columnValue)
  		{

Index: IUpdateQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/IUpdateQuery.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** IUpdateQuery.cs	16 Nov 2005 07:01:48 -0000	1.5
--- IUpdateQuery.cs	12 Jan 2006 05:42:34 -0000	1.6
***************
*** 14,17 ****
--- 14,22 ----
  		void Add(string columnName);
  		/// <summary>
+ 		/// Adds the specified column with a NULL value
+ 		/// </summary>
+ 		/// <param name="columnName">The name of the column</param>
+ 		void AddNull(string columnName);
+ 		/// <summary>
  		/// Adds the column name and value to the update query
  		/// </summary>