我用Delphi 5 ADO 我用兩個TADOTable分連住兩Table(Master & Detail)(圖一) Tform 上有兩個button，一個是Button1，另一個是Button2， 當我按下button1時(原想把Detail的Status='C'的filter走)，但卻出現以下Errror message(圖二)，請問應如何解決? < src="http://delphi.ktop.com.tw/loadfile.php?TOPICID=16927679&CC=378581"> (圖一) (圖二)

 
unit Unit1;    interface    uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Grids, Wwdbigrd, Wwdbgrid, Db, Wwdatsrc, ADODB;    type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    tbMaster: TADOTable;
    tbDetail: TADOTable;
    wwDataSource1: TwwDataSource;
    wwDataSource2: TwwDataSource;
    wwDBGrid1: TwwDBGrid;
    wwDBGrid2: TwwDBGrid;
    Button1: TButton;
    Button2: TButton;
    Label1: TLabel;
    Label2: TLabel;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;    var
  Form1: TForm1;    implementation    {$R *.DFM}    procedure TForm1.FormCreate(Sender: TObject);
begin
  tbMaster.close; tbMaster.open;
  tbDetail.close; tbDetail.open;
end;    procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  tbMaster.close;
  tbDetail.close;
  action:=cafree;
end;    procedure TForm1.Button1Click(Sender: TObject);
begin
  tbDetail.Filtered:=false;
  tbDetail.Filter:='Status<>''C''';
  tbDetail.Filtered:=true;
end;
end.    

You can make use of the OnFilterRecord event of your detail dataset. However you may find it necessary to close and reopen the detail dataset sometimes after applying the filter...

如果你要做主明細的功能,建議你可以用比較通用的主明細關聯方式,例如透過MasterDatasource去做明細和主檔之間的關聯,或是利用query去做sql語法的處理會比較好一點 Pillar Wang

------
Pillar Wang