请帮我看下,下面错在哪里了~~~感谢各位高手了mySQl = "delete from madmpeo where InfoNo='" & TxtInfID(2).Text & "'" & Chr(13) & _
"insert into madmpeo(PeoNo,InfoNo,PeoName,PeoIDNO,PeoSex,PeoUnit,PeoOffice,PeoZW,WorkIDNo,OfficeTel,UnitAddr,MobileTel,MoveOldUnit,EatCardNo,CarCardNo,MoveBeginDate,MoveEndDate,WorkType,MoveFlag,EatCardType,CarUse,ISCityWorkFlag,OutInRights) " & Chr(13) & _
"values('" & myPeoNo & "','" & TxtInfID(2).Text & "','" & txtName(10).Text & "','" & TxtIDcard(14).Text & "','" & TxtSex(24).Text & "','" & TxtDept(11).Text & "','" & TxtOffice(25).Text & "','" & TxtPeoZW(13).Text & "','" & TxtWordID(27).Text & "','" & TxtOfficetel(28).Text & "'" & _
", '" & TxtAddress(15).Text & "','" & TxtModelTel(29).Text & "','" & TxtOldoffice(30).Text & "','" & TxtInfID(0).Text & "','" & TxtInfID(1).Text & "','" & TxtLbl(2).Text & "-" & TxtLbl(37).Text & "-" & TxtLbl(38).Text & "','" & TxtLbl(39).Text & "-" & TxtLbl(10).Text & "-" & TxtLbl(13).Text & "'" & _
",'" & myWorkType & "','" & IIf(OptMoveFlag(0).Value = True, 1, 0) & "','" & myEatCardType & "','" & myCarUse & "','" & IIf(OptISCityWorkFlag(0).Value = True, 1, 0) & "','" & myOutInRights & "')"
"insert into CardLed(PeoNo,CardDate,Memo)"& Chr(13) & _
"values('" & myPeoNo & "','" & TxtCardDateY(0).Text & "-" & TxtCardDateM(0).Text & "-" & TxtCardDateD(0).Text & "','" & TxtCardDateY(1).Text & "-" & TxtCardDateM(1).Text & "-" & TxtCardDateD(1).Text & "','" & TxtCardDateY(2).Text & "-" & TxtCardDateM(2).Text & "-" & TxtCardDateD(2).Text & "','" & TxtCardDateY(3).Text & "-" & TxtCardDateM(3).Text & "-" & TxtCardDateD(3).Text & "','" & TxtCardDateY(4).Text & "-" & TxtCardDateM(4).Text & "-" & TxtCardDateD(4).Text & "','" & TxtMemo(0).Text &"')"& _
strReturn = MyExecSQL(mySQl)
"insert into madmpeo(PeoNo,InfoNo,PeoName,PeoIDNO,PeoSex,PeoUnit,PeoOffice,PeoZW,WorkIDNo,OfficeTel,UnitAddr,MobileTel,MoveOldUnit,EatCardNo,CarCardNo,MoveBeginDate,MoveEndDate,WorkType,MoveFlag,EatCardType,CarUse,ISCityWorkFlag,OutInRights) " & Chr(13) & _
"values('" & myPeoNo & "','" & TxtInfID(2).Text & "','" & txtName(10).Text & "','" & TxtIDcard(14).Text & "','" & TxtSex(24).Text & "','" & TxtDept(11).Text & "','" & TxtOffice(25).Text & "','" & TxtPeoZW(13).Text & "','" & TxtWordID(27).Text & "','" & TxtOfficetel(28).Text & "'" & _
", '" & TxtAddress(15).Text & "','" & TxtModelTel(29).Text & "','" & TxtOldoffice(30).Text & "','" & TxtInfID(0).Text & "','" & TxtInfID(1).Text & "','" & TxtLbl(2).Text & "-" & TxtLbl(37).Text & "-" & TxtLbl(38).Text & "','" & TxtLbl(39).Text & "-" & TxtLbl(10).Text & "-" & TxtLbl(13).Text & "'" & _
",'" & myWorkType & "','" & IIf(OptMoveFlag(0).Value = True, 1, 0) & "','" & myEatCardType & "','" & myCarUse & "','" & IIf(OptISCityWorkFlag(0).Value = True, 1, 0) & "','" & myOutInRights & "')"
"insert into CardLed(PeoNo,CardDate,Memo)"& Chr(13) & _
"values('" & myPeoNo & "','" & TxtCardDateY(0).Text & "-" & TxtCardDateM(0).Text & "-" & TxtCardDateD(0).Text & "','" & TxtCardDateY(1).Text & "-" & TxtCardDateM(1).Text & "-" & TxtCardDateD(1).Text & "','" & TxtCardDateY(2).Text & "-" & TxtCardDateM(2).Text & "-" & TxtCardDateD(2).Text & "','" & TxtCardDateY(3).Text & "-" & TxtCardDateM(3).Text & "-" & TxtCardDateD(3).Text & "','" & TxtCardDateY(4).Text & "-" & TxtCardDateM(4).Text & "-" & TxtCardDateD(4).Text & "','" & TxtMemo(0).Text &"')"& _
strReturn = MyExecSQL(mySQl)
解决方案 »
- 关于在电脑屏幕直接输出想要的图形,游戏外挂必备!
- dtpicker自定义格式
- mscomm rs232串口数据溢出问题
- 请考虑过微积分的朋友帮忙看看!(分少以后在加,就这么多了)。
- 猜猜有多少人在线??
- adodc1控件怎样传递一个参数到SQL存储过程。
- 贴一下一段关于ado查找记录的程序,显示“实时错误-1247352571,发生未知错误”?
- COM+中如何将一个自定义TYPE类型在服务器与客户端之间传递?
- 在picture中如果清除某些东西,如一条曲线,怎样在不重画picture的情况下实现?实现了立刻给分
- 请问各位神虾,如何在VB下编写整个硬盘文件搜索程序
- 怎样使用vb调用webservice?在线等!!!!!!!!
- 高手帮忙了---高手帮忙了----高手帮忙了----高手帮忙了---算法高手
"insert into madmpeo(PeoNo,InfoNo,PeoName,PeoIDNO,PeoSex,PeoUnit,PeoOffice,PeoZW,WorkIDNo,OfficeTel,UnitAddr,MobileTel,MoveOldUnit,EatCardNo,CarCardNo,MoveBeginDate,MoveEndDate,WorkType,MoveFlag,EatCardType,CarUse,ISCityWorkFlag,OutInRights) " & Chr(13) & _
"values('" & myPeoNo & "','" & TxtInfID(2).Text & "','" & txtName(10).Text & "','" & TxtIDcard(14).Text & "','" & TxtSex(24).Text & "','" & TxtDept(11).Text & "','" & TxtOffice(25).Text & "','" & TxtPeoZW(13).Text & "','" & TxtWordID(27).Text & "','" & TxtOfficetel(28).Text & "'" & _
", '" & TxtAddress(15).Text & "','" & TxtModelTel(29).Text & "','" & TxtOldoffice(30).Text & "','" & TxtInfID(0).Text & "','" & TxtInfID(1).Text & "','" & TxtLbl(2).Text & "-" & TxtLbl(37).Text & "-" & TxtLbl(38).Text & "','" & TxtLbl(39).Text & "-" & TxtLbl(10).Text & "-" & TxtLbl(13).Text & "'" & _
",'" & myWorkType & "','" & IIf(OptMoveFlag(0).Value = True, 1, 0) & "','" & myEatCardType & "','" & myCarUse & "','" & IIf(OptISCityWorkFlag(0).Value = True, 1, 0) & "','" & myOutInRights & "')"& chr(13)& _
"insert into CardLed(PeoNo,CardDate,Memo)"& Chr(13) & _
"values('" & myPeoNo & "','" & TxtCardDateY(0).Text & "-" & TxtCardDateM(0).Text & "-" & TxtCardDateD(0).Text & "','" & TxtCardDateY(1).Text & "-" & TxtCardDateM(1).Text & "-" & TxtCardDateD(1).Text & "','" & TxtCardDateY(2).Text & "-" & TxtCardDateM(2).Text & "-" & TxtCardDateD(2).Text & "','" & TxtCardDateY(3).Text & "-" & TxtCardDateM(3).Text & "-" & TxtCardDateD(3).Text & "','" & TxtCardDateY(4).Text & "-" & TxtCardDateM(4).Text & "-" & TxtCardDateD(4).Text & "','" & TxtMemo(0).Text &"')"& _
strReturn = MyExecSQL(mySQl)