strSQL = " update HScore " _
& "set[sold]=" & Sold & "," & "[sprice]=" & _
Sprice & "," & "[ssquare]=" & Ssquare _
& "," & "[straffic]=" & Straffic & "," & "[dface]=" & _
Sface & "," & "[saddress]=" & Saddress & "," & _
"[score0]=" & score & _
"where [serialnum]='" & Trim(mskSerialnum.Text) & "'"
conSHouse.Execute strSQL在立即窗口中?strsql可得
update HDiscrib
set[dold]='七成以下',[dprice]=8900,[dsquare]=50,[dtraffic]='方便',[dface]='南',[daddress]='海运二村',[score0]=463
where [serialnum]='100002'
这个语句在visuaData中可以执行 ,但是在程序中,却出现
“语法错误(操作符丢失)在查询表达式‘501 where[serialnum]='100002''中请高手指教,在线等呀
& "set[sold]=" & Sold & "," & "[sprice]=" & _
Sprice & "," & "[ssquare]=" & Ssquare _
& "," & "[straffic]=" & Straffic & "," & "[dface]=" & _
Sface & "," & "[saddress]=" & Saddress & "," & _
"[score0]=" & score & _
"where [serialnum]='" & Trim(mskSerialnum.Text) & "'"
conSHouse.Execute strSQL在立即窗口中?strsql可得
update HDiscrib
set[dold]='七成以下',[dprice]=8900,[dsquare]=50,[dtraffic]='方便',[dface]='南',[daddress]='海运二村',[score0]=463
where [serialnum]='100002'
这个语句在visuaData中可以执行 ,但是在程序中,却出现
“语法错误(操作符丢失)在查询表达式‘501 where[serialnum]='100002''中请高手指教,在线等呀
解决方案 »
- vb调用vc dll ,"DLL 调用约定错误"
- 如何在PictureBox上把文字顺时针或逆时针旋转90度?
- 如何获得局域网......高分相送?
- 关于数据库查询返回结果问题
- 大哥大姐们快帮帮我,我有一道VB题不会,真是急啊
- 用VB怎样控制在IE浏览器中打开指定的网页
- 怎么操作引号??
- *****高分求教,如何将DATAGRID显示的内容转化为EXCEL表,最好能提原码,本人初学者****
- 我在做VBSCRIPT时碰到的数据无法棒定问题
- 如何用代码的方式将recordset记录集个字段数据依照MsHflexgrid标题上各栏将数据显示出来
- 关于 shockwave flash1.0 控件的细节问题的请教
- 高手请进:如下代码:cnA.Execute "delete from A,B,C where (A.班级='2BAN') and (A.编号=B.编号) and (A.编号=C.编号)"
你可以在conSHouse.Execute strSQL这语句上监视一下,看看strSql语句的内容或者看一下行成这个Sql语句的那些变量的值。
祝你好运!