大哥大姐，求教SQL delete问题(100)

E

ehua818

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-04

• #1

SQL.Add('delete from ktv_temp where bh = ''4 '' '); 这句可以删除编号为4的数据为什么下面的不可以删除自己添加的数据，没有错误提示.SQL.Add('delete from ktv_temp where bh = '' +Trim(edit1.text)+'' ');

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-04

• #2

SQL.Add('delete from ktv_temp where bh = ''' +Trim(edit1.text)+''' ');

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-04

• #3

1楼的正确~~字符串的话，需要3对引号

 

S

Supermay

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-04

• #4

对单引号使用不熟悉就用QuotedStr()吧SQL.Add('delete from ktv_temp where bh = ' +QuotedStr( Trim(edit1.text)));

 

F

fsse4000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-05

• #5

SQL.Add( Format('delete from ktv_temp where bh =''%S'' ',[Trim(edit1.text)]));

 

A

abtf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-05

• #6

这样就可以了（www.NewSureSoft.com解答）SQL.Add('delete from ktv_temp where bh = ''' +Trim(edit1.text)+''' ');

 

常

常广荣

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-05

• #7

SQL.Add('delete from ktv_temp where bh = '+quotedstr(trim(edit1.text)));

 

Z

zaorv

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-06

• #8

Supermay:方法更好 ，

 

E

ehua818

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-06

• #9

多人接受答案了。