update 错在哪了?--新手 你应该把整个update写到""里,构成sql语句,然后赋值给ado控件的属性 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Update base _& " Set jineng = Me.Text6.Text,.........Text3.Text," _ & " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"-------------同意楼上的,不然系统将会把Update base当做函数名," Set jineng = Me.Text6.Text,.........Text3.Text," _ & " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"当做参数 cn.excute "update kkk set 字段=....." 好象问过了吔 ^_^Dim strSql As StringstrSql = _ "UPDATE xsdahhb" & _ "SET" & vbCrLf & _ " NAME ='" + Trim(Text1.Text) + "'," & vbCrLf & _ " XINGBIE ='" + Trim(Text2.Text) + "'," & vbCrLf & _ " AGE ='" + Trim(Text3.Text) + "'," & vbCrLf & _ " BRIDAY ='" + Trim(Text4.Text) + "'," & vbCrLf & _ " ADDR ='" + Trim(Text5.Text) + "'," & vbCrLf & _ " TEL ='" + Trim(Text6.Text) + "'," & vbCrLf & _ " SUB ='" + Trim(Text7.Text) + "'," " CLASS ='" + Trim(Text8.Text) + "'," & vbCrLf & _ " ZHIWU ='" + Trim(Text9.Text) + "' " & vbCrLf & _ "WHERE NAME='" + Trim(Text0.Text) & "'"cn.Excute strSql dim sql as string sql="Update base _ & " Set jineng = Me.Text6.Text,.........Text3.Text," _ & " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"gcn.execute(sql)为什么提示我 至少一个参数没有赋值。 这是因为数据库表至少有一个不允许为NULL的字段没有赋值所以你要在UPDATE语句中为它提供值 vb ACTIVEX 运行时是否需要 VB运行库? VB如何进行屏幕截图呢? 关于分布式系统开发.知道的指点一二 初学VB,小问题 二百分求,VB程序中一条select语句的提速与优化方法!! 高分求救啊,200分 请问一个关于Object对象的问题(绝对给分)。 大家來討論VB的新方向!(來者有分) 怎么使用image control 如何监视我们可怜的注册表? 高手請進.... 关于标签的问题
& " Set jineng = Me.Text6.Text,.........Text3.Text," _
& " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"
-------------
同意楼上的,不然系统将会把Update base当做函数名," Set jineng = Me.Text6.Text,.........Text3.Text," _
& " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"
当做参数
strSql = _
"UPDATE xsdahhb" & _
"SET" & vbCrLf & _
" NAME ='" + Trim(Text1.Text) + "'," & vbCrLf & _
" XINGBIE ='" + Trim(Text2.Text) + "'," & vbCrLf & _
" AGE ='" + Trim(Text3.Text) + "'," & vbCrLf & _
" BRIDAY ='" + Trim(Text4.Text) + "'," & vbCrLf & _
" ADDR ='" + Trim(Text5.Text) + "'," & vbCrLf & _
" TEL ='" + Trim(Text6.Text) + "'," & vbCrLf & _
" SUB ='" + Trim(Text7.Text) + "',"
" CLASS ='" + Trim(Text8.Text) + "'," & vbCrLf & _
" ZHIWU ='" + Trim(Text9.Text) + "' " & vbCrLf & _
"WHERE NAME='" + Trim(Text0.Text) & "'"
cn.Excute strSql
sql="Update base _
& " Set jineng = Me.Text6.Text,.........Text3.Text," _
& " kao_jibe=me.Text4.Text,.......classname=me.Text9.Text"
gcn.execute(sql)
为什么提示我 至少一个参数没有赋值。
所以你要在UPDATE语句中为它提供值