Hi Charlie!
Normally when I construct a filter string I do it like this and it works
fine:
if SortGrid.ItemIndex = 2 then
begin
tblUpdateOrders_.Close;
tblUpdateOrders_.Filtered := False;
tblUpdateOrders_.Filter := ' NUMBERTO = ''' +
' AND TYPE <> ' + QuotedStr(I) +
' AND TYPE <> ' + QuotedStr(Q) +
' AND TYPE <> ' + QuotedStr(C);
tblUpdateOrders_.Filtered := True;
tblUpdateOrders_.IndexFieldName := tblUpdateOrders_Wood.AsString;
tblUpdateOrders_.Open;
end;
-----Original Message-----
From: Charlie [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 12:44 AM
To: [email protected]
Subject: Any Idea
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
DISCLAIMER:
This message and any attachments are confidential and intended solely for
the addressee. If you have received this message in error, please notify the
system manager/sender. Any unauthorized use, alteration or dissemination is
prohibited. The Department of Water Affairs and Forestry further accepts no
liability whatsoever for any loss, whether it be direct, indirect or
consequential, arising from this e-mail, nor for any consequence of its use
or storage.
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk
