sql与edit中的加减问题！(10分)

Y

yyjqtww

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #1

try
with Query2 do
begin
Close;
SQL.Text := 'update ykucuntab set total=total+strtoint(edit8.text)' + ' where isbn='+''''+edit2.text+''''+'';
ExecSQL;
end;
except
raise
end
这段代码中有
total=total+strtoint(edit8.text)
可是运行时出错，为什么呢！我想将表中的total字段加上edit8中的内容，请问应该如何实现呢？

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #2

SQL.Text := 'update ykucuntab set total=total+'+
strtoint(edit8.text) + ' where isbn='+''''+edit2.text+''''+'';

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #3

SQL.Text := 'update ykucuntab set total=total+'+
strtoint(edit8.text) + ' where isbn='+ QuotedStr(edit2.text);

 

J

jrq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #4

strtoint（）肯定不能写在SQL里面了

 

Y

yanh_98

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #5

就是这样。同意yzhshi的答案。

 

L

LGXing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #6

SQL.Text := 'update ykucuntab set total=total+'+
edit8.text + ' where isbn='#39 + edit2.text + #39;

 

M

mlzhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-24

• #7

SQL.Text := 'update ykucuntab set total=total+'+edit8.text + ' where isbn='+''''+edit2.text+'''';