[Adapdev-commits] Adapdev/src/Adapdev.CodeGen NVelocityTableCodeTemplate.cs,1.5,1.6

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

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10399/src/Adapdev.CodeGen

Modified Files:
	NVelocityTableCodeTemplate.cs 
Log Message:
Added SortableCollectionBase
Changed ObjectComparer to ObjectSorter
Updated ProviderInfo to include Oracle Provider Data Types
Added some missed sql types that require lengths for sp generation

Index: NVelocityTableCodeTemplate.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen/NVelocityTableCodeTemplate.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** NVelocityTableCodeTemplate.cs	1 May 2005 02:39:28 -0000	1.5
--- NVelocityTableCodeTemplate.cs	13 May 2005 03:51:26 -0000	1.6
***************
*** 316,325 ****
  			switch(c.DataType.ToLower())
  			{
  				case "char":
  				case "nchar":
  				case "nvarchar":
  				case "varchar":
  					return "(" + c.Length + ")";
- 					break;
  			}
  			return String.Empty;
--- 316,326 ----
  			switch(c.DataType.ToLower())
  			{
+ 				case "binary":
  				case "char":
  				case "nchar":
  				case "nvarchar":
+ 				case "varbinary":
  				case "varchar":
  					return "(" + c.Length + ")";
  			}
  			return String.Empty;
***************
*** 377,389 ****
  			foreach(ColumnSchema cs in al)
  			{
! 				if(i < al.Count)
! 				{
! 					sb.Append(this.GetParameterText(cs) + "," + Environment.NewLine);
! 				}
! 				else 
  				{
! 					sb.Append(this.GetParameterText(cs) + Environment.NewLine);
  				}
- 				i++;
  			}
  			return sb.ToString();
--- 378,393 ----
  			foreach(ColumnSchema cs in al)
  			{
! 				if(cs.IsActive)
  				{
! 					if(i < al.Count)
! 					{
! 						sb.Append(this.GetParameterText(cs) + "," + Environment.NewLine);
! 					}
! 					else 
! 					{
! 						sb.Append(this.GetParameterText(cs) + Environment.NewLine);
! 					}
! 					i++;
  				}
  			}
  			return sb.ToString();