请问如何在DELPHI中运用SQL语句！我的代码来执行不通，请高手指点一下！ ( 积分: 100 )

D

DYI

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #1

执行下面代码，老执行不通！请高手指教！<br>procedure&nbsp;TForm2.Button1Click(Sender:&nbsp;TObject);<br>begin<br>adoquery1.Close;<br>adoquery1.SQL.Clear;<br>adoquery1.SQL.Add('update&nbsp;users&nbsp;set<br>password='1234'<br>where&nbsp;u_code='Demo'');<br>adoquery1.ExecSQL&nbsp;;<br>end;<br>end;<br><br>end.

 

水

水竹天平

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #2

你的SQl语句应该在同一行上

 

T

tkggai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #3

注意：字符串的两头要多加&nbsp;单引号<br>procedure&nbsp;TForm2.Button1Click(Sender:&nbsp;TObject);<br>begin<br>adoquery1.Close;<br>adoquery1.SQL.Clear;<br>adoquery1.SQL.Add('update&nbsp;users&nbsp;set<br>password=''1234''<br>where&nbsp;u_code=''Demo''&nbsp;');<br>adoquery1.ExecSQL&nbsp;;<br>end;<br>end;<br><br>end.

 

出

出现派

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #4

要这样写哦，呵呵。自己研究一下吧~~<br>procedure&nbsp;TForm2.Button1Click(Sender:&nbsp;TObject);<br>begin<br>&nbsp;&nbsp;adoquery1.Close;<br>&nbsp;&nbsp;adoquery1.SQL.Clear;<br>&nbsp;&nbsp;adoquery1.SQL.Add('update&nbsp;users&nbsp;set&nbsp;password='+'''1234'''&nbsp;+&nbsp;'&nbsp;where&nbsp;u_code='&nbsp;+&nbsp;'''Demo''');<br>&nbsp;&nbsp;adoquery1.ExecSQL&nbsp;;<br>end;

 

出

出现派

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #5

楼上的朋友，我们的ID竟然是夫妻号~~[]

 

X

xxj0828

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-18

• #6

adoquery1.Close;<br>adoquery1.SQL.Clear;<br>adoquery1.SQL.Add('update&nbsp;users&nbsp;set&nbsp;password='''1234'''&nbsp;where&nbsp;u_code='''Demo'''');<br>adoquery1.ExecSQL&nbsp;;

 

D

DYI

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-19

• #7

我已经提前自己研究出来了，已经解决！谢谢！