为什么我的commandtext语句加where ... 后就没有记录了呢(40分)

W

whhzkl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #1

在我的三层结构的客户端有一个DbGrid1连着dm.CDSPntBasic(Clientdataset):
dm.CDSPntBasic.CommandText := '';
dm.CDSPntBasic.CommandText:='select * from PntBasic where replace(DEPTNAME,'+'''' + ' '+'''' + ',' + ''''+''''+') = '+''''+aaa+'''';
dm.CDSPntBasic.Execute;
dm.CDSPntBasic.Open;
dm.CDSPntBasic.Active := true;
问题是：
如果Sql语句里没有where语句，就可以返回数据集， 而加上where语句（如上）后返回为空数据集。为什么？
谢谢大家！！！！！！！！！！！！！！！！！！！！！！！！！！

 

M

mstar

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #2

select * from PntBasic where DEPTNAME like '''*'+aaa+'*'''

 

花

花形

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #3

select * from PntBasic where DEPTNAME like '''%'+aaa+'%'''

 

W

weiwei_lxl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #4

'select * from PntBasic where DEPTNAME like '+ '''%'+aaa+'%'''

 

W

whhzkl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #5

xiexie
aaa:=stringReplace(TV.Selected.Text,' ','',[rfReplaceAll]);
dm.CDSPntBasic.Close;
dm.CDSPntBasic.CommandText := '';
dm.CDSPntBasic.CommandText:='select * from PntBasic '+
'where replace(DEPTNAME,'+''''+' '+''''+','+''''+''+''''+')'+' like '+''''+aaa+'''' ;
dm.CDSPntBasic.Execute;
dm.CDSPntBasic.Open;
dm.CDSPntBasic.Active := true;

 

花

花形

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #6

dm.CDSPntBasic.CommandText:='select * from PntBasic '+
'where replace(DEPTNAME,'+''''+' '+''''+','+''''+''+''''+')'+' like '+'''%'+aaa+'%''' ;

 

D

dez_0609

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-04-08

• #7

dm.CDSPntBasic.CommandText:='select * from PntBasic where replace(DEPTNAME,'' '','''') like '+QuotedStr('%'+aaa+'%');