public override string FilterValues() { UpdateValues(); QueryFilterOperation op = QueryFilterOperation.GetByName(Filter); if (op == null) { return(null); } else { return(op.FilterSql(false, Column, Value1, Value2)); } }
public override string FilterValues() { UpdateValues(); string pv = Statement.EscapeQuotes(Value1); string pv2 = (spinButton2 == null) ? null : Statement.EscapeQuotes(Value2); QueryFilterOperation op = QueryFilterOperation.GetByName(Filter); if (op == null) { return(null); } else { return(op.FilterSql(false, String.Format("(strftime(\"%s\", current_timestamp) - {0})", Column), pv, pv2)); } }
public override string FilterValues() { UpdateValues(); string val1 = Statement.EscapeQuotes(Value1.ToLower()); string col = String.Format("lower({0})", Column); QueryFilterOperation op = QueryFilterOperation.GetByName(Filter); if (op == null) { return(null); } else { return(op.FilterSql(true, col, val1, null)); } }