如下SQL语句,在SQL2000的查询分析器和VisualFoxpro9.0都可以执行,可在BDE中用Query就不能执行,咋回事哟?该如何解决?
SELECT * FROM zc04c WHERE xm+xb in (SELECT xm+xb FROM zc04c GROUP BY xm,xb HAVING COUNT(*)>=2) ORDER BY xm,xb
SELECT * FROM zc04c WHERE xm+xb in (SELECT xm+xb FROM zc04c GROUP BY xm,xb HAVING COUNT(*)>=2) ORDER BY xm,xb
------------------------------------
体验速度,体验CSDN论坛助手:http://community.csdn.net/Expert/TopicView.asp?id=4700683
如果你是用bde连sql2000/vfoxpro(有9.0版吗?我只用到过6.0)出现问题,建议改bde为ado,因为用ado连microsoft的数据库肯定比BDE好
如:
var
s: String;
begin
Edit1.Text := 'Test';
s := 'Test1(' + Edit1.Text + ')Test2';
//执行后s的值变为Test1(Test)Test2
s := 'Test1(Edit1.Text)Test2';
//执行后s的值变为Test1(Edit1.Text)Test2
s := 'Test1(' + '''' + Edit1.Text + '''' + 'Test2';
//执行后s变为Test1('Test')Test2
end;
因为项目需要,数据必须用DBF,用ADO,很多DBF又会有乱码。
郁闷中..........