简单的SQL语句书写。有错吗？(10分)

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #1

sqlstr:='select * from NowStorage where %s like "%%s%"';
ADOQuery1.SQL.Text :=format(SQLSTR,['FieldName',Edit1.text]);
ADOQuery1.open;

总是报错？？

请问如何修改？？？？？？？？？？？？？？？？？？

 

L

liner_02

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #2

错误是什么

 

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #3

Format '%"' invalid or incompatible with argument

 

5

52free

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #4

sqlstr:='select * from NowStorage where %s like %s%s%s';
ADOQuery1.SQL.Text :=format(SQLSTR,['FiedlName','"',Edit1.text,'"']);

 

R

realLearning

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #5

"%%s%"'程序不知道怎么替换。

 

Z

zdz_conquer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #6

ADOQuery1.SQL.Text :=format('select * from NowStorage where %s like %s,['FieldName',quotedstr('%'+Edit1.text+'%')]);
ADOQuery1.open;

是由于 % 引起的语句混淆

 

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #7

to: 52free
好象不行吧。。错误。。。

to:realLearning:
其实我也知道问题出在 "%%s%"'..难道没有办法解决？？

 

雪

雪山松男

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #8

sqlstr:='select * from NowStorage where %s like %s%s%s';
ADOQuery1.SQL.Text :=format(SQLSTR,['FiedlName','"',Edit1.text,'"']);
ADOQuery1.open;

 

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #9

TO:雪山松男
语法错误(操作符丢失)在查询表达式 'FieldName like ="111'中。

 

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #10

sqlstr:='select * from NowStorage where %s like %s%s%s';
ADOQuery1.SQL.Text :=format(SQLSTR,['FiedlName','"%',Edit1.text,'%"']);
ADOQuery1.open;

或

ADOQuery1.SQL.Text :=format('select * from NowStorage where %s like %s,['FieldName',quotedstr('%'+Edit1.text+'%')]);
ADOQuery1.open;

都是对的。是我搞错了。

不过你们的回答中。总是搞错 % 与 " 或搞掉 % 与 "

 

I

inbreak

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-06-28

• #11

多人接受答案了。