does anyone have any idea as to how to resolve the following for me?

What do I need to do to the following filter expression so that I not get at
runtime "Filter expression incorrectly terminated"

  if SortGrid.ItemIndex = 2 then
    begin
      tblUpdateOrders_.Close;
      tblUpdateOrders_.Filtered := False;
      tblUpdateOrders_.Filter := 'NUMBERTO = ''' + 'TYPE <>
QuotedStr(I)'+'NUMBERTO = ''' + 'TYPE <> QuotedStr(Q)' + 'NUMBERTO = ''' +
'TYPE <> QuotedStr(C)';
      tblUpdateOrders_.Filtered := True;
      tblUpdateOrders_.IndexFieldName := tblUpdateOrders_Wood.AsString;
      tblUpdateOrders_.Open;
    end;

Charlie Kerscher
Williamson GA 30292
770.468.1757
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk

Reply via email to