一个简单的sql语句的问题。在线等，解决后给分(100分)

P

panchenglin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #1

s := 'Select * from gzhkk where e021= '''+ aLmkh +''' and ifnull(f017,'')&lt;&gt;''';<br><br>测试跟踪得到s:<br>Select * from gzhkk where e021= '2703000101023175436' and ifnull(f017,')&lt;&gt;''<br><br>而我期望得到<br>Select * from gzhkk where e021= '2703000101023175436' and ifnull(f017,'')&lt;&gt;''<br><br>也就是f017,后面多了个'<br>.请知道的朋友说一下。

 

S

shadowpj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #2

s := 'Select * from gzhkk where e021= '''+ aLmkh +''' and ifnull(f017,'''')&lt;&gt;';

 

小

小无为

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #3

s := 'Select * from gzhkk where e021= '''+ aLmkh +''' and ifnull(f017,")&lt;&gt;'; &nbsp;<br>用shift上档键

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #4

delphi里二个''代表1个' 要二个'Delphi的字符串就要四个'

 

小

小无为

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #5

用shift上档一样，关键是双引号“

 

C

Corn3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #6

s := 'Select * from gzhkk where e021= '''+ aLmkh +''' and ifnull(f017,'''')&lt;&gt;'''''

 

X

XCC

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #7

楼上正解

 

P

panchenglin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-09

• #8

Corn3朋友的答案是正确的.分数给大家分一下。