200分求答案 ( 积分: 200 )

L

lfzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #1

SQL.Clear;
SQL.Add('UPDATE FI01PIN' );
SQL.Add('set I_BJ="1"');
SQL.Add('WHERE ISNULL(I_BOXNO,'') IN ');
SQL.Add('(SELECT ISNULL(H_BOXNO,'') FROM FH01PIN01) ');
ExecSQL;
这一段我在查询分析器里执行OK了，为什么放进ADO里就不行了呢？

 

S

s00000000001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #2

注意单引号和空格的问题

 

B

Buddy.Sun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #3

set I_BJ="1"
这里，你需要先把双引号开关打开，
一般使用
'set i_BJ = ' + quotedstr('1')

 

L

louqing_2

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #4

SQL.Add('WHERE ISNULL(I_BOXNO,'''') IN ');
SQL.Add('(SELECT ISNULL(H_BOXNO,'''') FROM FH01PIN01) ');

 

清

清新空气

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #5

看看是不是你的空格掉了？
SQL.Clear;
SQL.Add('UPDATE FI01PIN' );
SQL.Add('set I_BJ="1"');
SQL.Add('[red]_[/red]WHERE ISNULL(I_BOXNO,'') IN ');
SQL.Add('[red]_[/red](SELECT ISNULL(H_BOXNO,'') FROM FH01PIN01) ');
ExecSQL;

 

S

s00000000001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #6

SQL.Clear;
SQL.Add('UPDATE FI01PIN' );
SQL.Add(' set I_BJ="1"');
SQL.Add(' WHERE ISNULL(I_BOXNO,'''') IN ');
SQL.Add(' (SELECT ISNULL(H_BOXNO,'''') FROM FH01PIN01) ');
ExecSQL;

 

L

lcmlhs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #7

帮你顶，接个分

 

L

lfzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #8

看出来了，厉害，散分了

 

B

Buddy.Sun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #9

双引号开关
SET QUOTED_IDENTIFIER ON/OFF

 

L

lfzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #10

哈

 

S

softdelphi8

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-25

• #11

SQL.Add('UPDATE FI01PIN set I_BJ='''1''' WHERE ISNULL(I_BOXNO,0) IN (SELECT ISNULL(H_BOXNO,0) FROM FH01PIN01') ;

 

L

lili365

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-23

• #12

SQL.Clear;
SQL.Add('UPDATE FI01PIN' );
SQL.Add('set I_BJ=''1'''');
SQL.Add('WHERE ISNULL(I_BOXNO,'''') IN ');
SQL.Add('(SELECT ISNULL(H_BOXNO,'''') FROM FH01PIN01) ');
ExecSQL;