Hi All,

I have a good question, well I think it is a good question...

I have a object Array and I pass values to this object array such as "12",456.89, 122

I want to determine the type of each variable as it affects the way I will build by dynamic where clause.

this is what I have so far.

But I get an error on the comparing of system.int to the object.getType function look for ********************> to see the starting line I am talking about.

The error is : 'short' denotes a 'class' where a 'variable' was expected

using System;
using OakLeaf.MM.Main;

namespace Apps4u.WinApp.Business.Search
{
	/// <summary>
	/// The SearchCritieria Class will contain functions to manipulate and validate the search criteria
	/// </summary>
	public class SearchCriteria
	{
		
		protected bool SearchValidate_Completed_ErrorFree = false;

		public SearchCriteria()
		{
		}

		/// <summary>
		/// This method will validate the string to ensure it has no invalid characters in it.
		/// </summary>
		/// <param name="SearchArray">receives an Object Array from the GUI</param>
		/// <returns>Returns True or False</returns>
		public bool SearchValidateStrings(params object[] SearchArray)
		{
			
			foreach (object ValidDataArray in SearchArray)
			{
				// TODO : Add a regular expression search here to validate the array elements
				// if (string is not valid)
				// {this.SearchValidate_Completed_ErrorFree = false; break;}
			}
			return this.SearchValidate_Completed_ErrorFree;
		}

		/// <summary>
		/// This method will build a string where clause
		/// </summary>
		/// <param name="SearchArray"></param>
		/// <returns></returns>
		public string BuildSearchWhereClause(params object[] SearchArray)
		{
			if (!this.SearchValidate_Completed_ErrorFree) return "";

			string sWhereClause, sFieldName1, sFieldName2 = "";
			bool lIsNotEmpty_Object = false;
			bool lOnFirstItem = true;

			foreach (object BuildStringArray in SearchArray)
			{
				// the first object is the field name which should always have a value
				// the second object is suppose to be the value from the form.
				// so we will test if the second object has a value
				if (lOnFirstItem)
				{
					lOnFirstItem = false;
					sFieldName1 = BuildStringArray.ToString();
				}
				else
				{
					lOnFirstItem = true;
					sFieldName2 = BuildStringArray.ToString() ;
				}
					
				// test to see if we have a value
				if (!mmString.Empty(sFieldName2)) lIsNotEmpty_Object = true;

				if (lIsNotEmpty_Object)
				{
					if (!mmString.Empty(sWhereClause)) sWhereClause += " AND ";
********************>
					if (BuildStringArray.GetType() == System.Int16 || BuildStringArray.GetType() == System.Int32 || BuildStringArray.GetType() == System.Int64  )
					{ sWhereClause += sFieldName1 + " = " + sFieldName2 ;}
					else if (BuildStringArray.GetType() == System.DateTime)
					{ sWhereClause += sFieldName1 + " = {" + sFieldName2 + "}";}
					else if (BuildStringArray.GetType() == System.String)
					{ sWhereClause += sFieldName1 + " = '" + sFieldName2 + "'";}
					
				}
			}
			return "";
		}
		
	}
}