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())); }