UPDATE table_referenceSET column_ref = update_atom [, column_ref = update_atom...]
[WHERE predicates]
for example:UPDATE table_referenceSET column_ref = update_atom [, column_ref = update_atom...]
[WHERE predicates]
上面才是正确的语法,没事多看看帮助吧!
[WHERE predicates]
for example:UPDATE table_referenceSET column_ref = update_atom [, column_ref = update_atom...]
[WHERE predicates]
上面才是正确的语法,没事多看看帮助吧!
datamodule9.Query1.SQL.Add('update user set pwd='''+edit3.Text+''' where name='''+edit4.text+'''');
怎么也出错了
说是
raise expection ENoResultSet with message "error creating cursor handle'
请问这是什么原因?
应该用Query1.ExeSql
datamodule9.Query1.ExecSQL('update user set pwd='''+edit3.Text+''' where name='''+edit4.Text+'''');[Error]too many actual parameters