select id,byyql,syds,lsqf,cbyf,dah,byds from openrowset('MICROSOFT.JET.OLEDB.4.0','dBase 5.0;DATABASE=d:\datebase\','select id,byyql,syds,lsqf,cbyf,dah,byds from [yhjbxx.dbf] Where Byds<>'''' ') a where cbyf=@VCBYF这一句原本是SQL2000里的存储过程我现在想把上面的SQL语句写到DELPHI里面去, 这个要怎么写啊????在线等
qrytmp.SQL.Text:='select * into goods from ';
qrytmp.SQL.Add('openrowset('+char(39)+'microsoft.Jet.OLEDB.4.0'+char(39)+','+char(39)+'D:\lawa.mdb'+char(39)+';'+char(39)+'admin'+char(39)+';'+char(39)+''+char(39)+',goods)');
qrytmp.ExecSQL;