D6, DBISAM V4.25b5

I've just changed the code in my mail and news client because I (finally) realised it wasn't working properly. I can't just change the filter or just refresh the table I have to explicitly turn the filter off and back on.

This may be WAD, or fixed in the intervening years but just in case.

// To's first
Recipients.Filtered := False;
Recipients.Filter := '_List = -1 OR _List = 0';
Recipients.Filtered := True;
if Recipients.RecordCount > 0 then ReplaceHeaderLine('To', recipList, sl);
// Now Cc's
Recipients.Filtered := False;
Recipients.Filter := '_List = 1';
Recipients.Filtered := True;
if Recipients.RecordCount > 0 then ReplaceHeaderLine('Cc', recipList, sl);
// Next Bcc's
Recipients.Filtered := False;
Recipients.Filter := '_List = 2';
Recipients.Filtered := True;
if Recipients.RecordCount > 1 then begin
 ReplaceHeaderLine('Bcc', recipList, sl);
 MsgOpts.HasBccs := True;
end else MsgOpts.HasBccs := False;
//

Roy Lambert

Roy,

<< I've just changed the code in my mail and news client because I (finally)
realised it wasn't working properly. I can't just change the filter or just
refresh the table I have to explicitly turn the filter off and back on. >>

I think this is working okay now, but I'll double-check.   I can't find any
incident reports on it, so it may have been fixed as part of another fix.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

Yeah, it appears to be working fine now.  The following works just fine:

  with DBISAMTable1 do
     begin
     Filter:='State=''FL''';
     Filtered:=True;
     Filter:='State=''HI''';
     end;

The result is all records with a State of 'HI'.

--
Tim Young
Elevate Software
www.elevatesoft.com