[Adapdev-commits] Adapdev/src/Adapdev.Data/Sql QueryConstants.cs,1.1.1.1,1.2 QueryHelper.cs,1.3,1.4

[Trevor L. <tre...@us...>]

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

Modified Files:
	QueryConstants.cs QueryHelper.cs 
Log Message:
Fixed Oracle issue with Parameters. Added ':' to the front of paramter placeholders.

Index: QueryConstants.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/QueryConstants.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** QueryConstants.cs	28 Feb 2005 01:31:48 -0000	1.1.1.1
--- QueryConstants.cs	20 May 2005 02:10:53 -0000	1.2
***************
*** 16,19 ****
--- 16,22 ----
  		public const char ACCESS_DATE = '#';
  
+ 		public const char ORACLE_STRING = '\'';
+ 		public const char ORACLE_DATE = '\'';
+ 
  	}
  }
\ No newline at end of file

Index: QueryHelper.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/QueryHelper.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** QueryHelper.cs	14 Apr 2005 03:43:41 -0000	1.3
--- QueryHelper.cs	20 May 2005 02:10:53 -0000	1.4
***************
*** 137,141 ****
  				case DbProviderType.ORACLE:
  					columnName = StringUtil.RemoveSpaces(columnName);
! 					return columnName;
  				case DbProviderType.OLEDB:
  					return "?";
--- 137,141 ----
  				case DbProviderType.ORACLE:
  					columnName = StringUtil.RemoveSpaces(columnName);
! 					return ":" + columnName;
  				case DbProviderType.OLEDB:
  					return "?";
***************
*** 158,162 ****
  
  		public static string GetOracleLastInsertedCommand(string table, string column) {
! 			string s = "SELECT MAX([" + column + "]) FROM " + table + ";";
  			Console.WriteLine(s);
  			return s;
--- 158,162 ----
  
  		public static string GetOracleLastInsertedCommand(string table, string column) {
! 			string s = "SELECT MAX(" + column + ") FROM " + table + ";";
  			Console.WriteLine(s);
  			return s;