public override string ToInfo()
{
if (WhereString.Length == 0)
{
WhereString.Append("WHERE ");
}
else
{
WhereString.Append(" AND ");
}
return(string.Format("select {0} from {1} {2} rownum <=1 {3};", GetFields(), TableName, WhereString, SortString));
}
public override string GetValue()
{
if (WhereString.Length == 0)
{
WhereString.Append("WHERE ");
}
else
{
WhereString.Append(" AND ");
}
return(string.Format("SELECT {0} FROM {1} {2} rownum <=1 {3};", GetFields(), TableName, WhereString,
SortString));
}