sql问题(5分)

I

ifcansee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-28

• #1

sqlxcx:='select sum(succ) as succ from
s12_a04b.dbf where name='181' or name='29'';

提示出错，如何在一个字符串中加入类似name='181'这样的语句，也就是说如何在
字符串中加入‘’

 

C

chelon

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-28

• #2

试试：
sqlxcx:='select sum(succ) as succ from
s12_a04b.dbf where name=''181'' or name=''29''';

 

K

KeepObject

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-28

• #3

这样写：
sqlxcx='select sum(succ) as succ from s12_a04b.dbf where name=''181'' or name=
''29''';

 

I

ifcansee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-29

• #4

多人接受答案了。