procedure TDM.CDS_ReadBeforeDelete(DataSet: TDataSet);
var
lpos:integer;
ltablename:string;
begin
ltablename:=CDS_Read.CommandText;
ltablename:=UPPERCASE(ltablename);
lpos:=pos('NCEPUMIS_DEPARTMENT.GYGL_',ltablename);
ltablename:=copy(ltablename,lpos,29);
with CDS_Read do
begin
close;
commandtext:='select * from '+ltablename+' where ID='
+Fieldbyname('ID').AsString;
Execute;
end;
end;
var
lpos:integer;
ltablename:string;
begin
ltablename:=CDS_Read.CommandText;
ltablename:=UPPERCASE(ltablename);
lpos:=pos('NCEPUMIS_DEPARTMENT.GYGL_',ltablename);
ltablename:=copy(ltablename,lpos,29);
with CDS_Read do
begin
close;
commandtext:='select * from '+ltablename+' where ID='
+Fieldbyname('ID').AsString;
Execute;
end;
end;
commandtext:='select * from '+ltablename+' where ID='''
+Fieldbyname('ID').AsString+'''';
Execute;
试试吧;
--------------------------------------
中间动力为您的发展提供源动力。
http://www.freewebs.com/middleware/