Access中sql语句的注意事项

来源：互联网发布：算法具有哪些重要特性编辑：程序博客网时间：2024/04/26 22:08

在Access中Sql语句中参数的顺序必须是一一对应的，eg：

update Tmp_TestReportZB set sReportNO=@sReportNO,sCpmc=@sCpmc,sGgxh=@sGgxh,sJylb=@sJylb ,sScph=@sScph ,sYpsl=@sYpsl,sSysl=@sSysl,dtmYprq=@dtmYprq,dtmSyrq=@dtmSyrq,sJyyg=@sJyyg,dtmJyrq=@dtmJyrq ,sYes=@sYes,sNote=@sNote where id=";
            sql_ZB = sql_ZB + DbUtils.GetInt(id);
            OleDbParameter[] parameters_ZB = {
                                              new OleDbParameter("@sReportNO",OleDbType.VarChar,50),
                                              new OleDbParameter("@sCpmc",OleDbType.VarChar,50),
                                              new OleDbParameter("@sGgxh",OleDbType.VarChar,50),
                                              new OleDbParameter("@sJylb",OleDbType.VarChar,50),
                                              new OleDbParameter("@sScph",OleDbType.VarChar,50),
                                              new OleDbParameter("@sYpsl",OleDbType.VarChar,50),
                                              new OleDbParameter("@sSysl",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmYprq",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmSyrq",OleDbType.VarChar,50),
                                              new OleDbParameter("@sJyyg",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmJyrq",OleDbType.VarChar,50),
                                              new OleDbParameter("@sYes",OleDbType.VarChar,50),
                                              new OleDbParameter("@sNote",OleDbType.VarChar,50),

｝

或者：

update Tmp_TestReportZB set sReportNO=@sReportNO,sCpmc=@sCpmc,sGgxh=@sGgxh ,sJylb=@sJylb ,sScph=@sScph ,sYpsl=@sYpsl,sSysl=@sSysl,dtmYprq=@dtmYprq,dtmSyrq=@dtmSyrq,sJyyg=@sJyyg,dtmJyrq=@dtmJyrq ,sYes=@sYes,sNote=@sNote where id=@id" new OleDbParameter("@MXid",OleDbType.Integer),;
            OleDbParameter[] parameters_ZB = {
                                              new OleDbParameter("@sReportNO",OleDbType.VarChar,50),
                                              new OleDbParameter("@sCpmc",OleDbType.VarChar,50),
                                              new OleDbParameter("@sGgxh",OleDbType.VarChar,50),
                                              new OleDbParameter("@sJylb",OleDbType.VarChar,50),
                                              new OleDbParameter("@sScph",OleDbType.VarChar,50),
                                              new OleDbParameter("@sYpsl",OleDbType.VarChar,50),
                                              new OleDbParameter("@sSysl",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmYprq",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmSyrq",OleDbType.VarChar,50),
                                              new OleDbParameter("@sJyyg",OleDbType.VarChar,50),
                                              new OleDbParameter("@dtmJyrq",OleDbType.VarChar,50),
                                              new OleDbParameter("@sYes",OleDbType.VarChar,50),
                                              new OleDbParameter("@sNote",OleDbType.VarChar,50),

new OleDbParameter("@id",OleDbType.Integer),

｝

0 0