public override string renderInSelect()
{
return(string.Format(
" ({0}) {1} ({2}) ",
select1.renderInSelect(),
ops[(int)op],
select2.renderInSelect()
));
}
public override string Render(Statement st)
{
if (values != null)
{
StringBuilder sb = new StringBuilder();
sb.Append(exp.Render(st));
if (!inOrNotIn)
{
sb.Append(" NOT ");
}
sb.Append("BETWEEN ( ");
foreach (object val in values)
{
sb.AppendFormat("({0}){1} ", renderValue(val), " ,");
}
sb.removeLastChar();
sb.Append(") ");
return(sb.ToString());
}
//======
if (table != null)
{
return(string.Format("(({0}) {1} ({2})", exp.Render(st), inOrNotIn ? "IN" : "NOT IN", table.renderInSelect()));
}
//======
if (select != null)
{
return(string.Format("(({0}) {1} ({2})", exp.Render(st), inOrNotIn ? "IN" : "NOT IN", select.renderInSelect()));
}
//not supposed to come here
return(null);
}
public override string Render(Statement st)
{
return(string.Format("EXISTS ({0})", select.renderInSelect()));
}
