是做資料庫修改操作的。不知道怎么回事兒一直這個問題!
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('update Stuinfo set StuID=:StuID,StuNo=:StuNo,Sex=:Sex,Class=:Class,DepartMent=:DepartMent,BrithDay=:BrithDay,NativePlace=:NativePlace,Stu_Name=:Stu_Name where Stu_Name=:Stu_Name');
ADOQuery1.Open;
ADOQuery1.Parameters.ParamValues['StuId']:=QuotedStr(trim(edit7.Text));
ADOQuery1.Parameters.ParamValues['StuNo']:=QuotedStr(trim(edit1.Text));
ADOQuery1.Parameters.ParamValues['DepartMent']:= QuotedStr(trim(edit4.Text));
ADOQuery1.Parameters.ParamValues['Class']:= QuotedStr(trim(edit3.Text));
ADOQuery1.Parameters.ParamValues['Stu_Name']:= QuotedStr(trim(edit2.Text));
ADOQuery1.Parameters.ParamValues['BrithDay']:=QuotedStr(trim(edit6.Text));
ADOQuery1.Parameters.ParamValues['NativePlace']:= QuotedStr(trim(edit5.Text));
if RadioButton1.Checked=True then
ADOQuery1.Parameters.ParamValues['Sex']:=RadioButton1.Caption;
if RadioButton2.Checked=True then
ADOQuery1.Parameters.ParamValues['Sex']:=RadioButton2.Caption;
ADOQuery1.ExecSQL;
uj5u.com熱心網友回復:
我印象中:Stu_Name這個引數有兩個且相同,好像系統不認,你寫成:Stu_Name1和:Stu_Name2試一試。uj5u.com熱心網友回復:
https://blog.csdn.net/leavesguth/article/details/77636561uj5u.com熱心網友回復:
Stu_Name=:Stu_Name where Stu_Name=:Stu_Name你使用了兩個同名的Stu_Name ,改一下重新賦值。或者你在SQL語法里增加SQL變數然后使用也行的(但更麻煩)。
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/267725.html
標籤:數據庫相關
上一篇:【C語言求助】嵌套回圈問題
