sCmd = "insert into xshp (time,ele,water) values ("
sCmd = sCmd + "'" + txtTime + "',"
sCmd = sCmd + "'" + txtEle + "',"
sCmd = sCmd + "'" + txtWater + "'" + ")"
sCmd = sCmd + "'" + txtTime + "',"
sCmd = sCmd + "'" + txtEle + "',"
sCmd = sCmd + "'" + txtWater + "'" + ")"
解决方案 »
- 大家帮帮我啊 找错误哦 我都找了2个小时都没有找出来,气哦 非常谢谢
- 一个有一定难度的点对点通讯问题,类似于QQ的点对点传文件
- 请问如何让客户端很容易的就能连接远程MYSQL啊?
- 请问在VB6.0下如何创建动态连接库
- VB应用程序从一个JAVA程序中获得字符串(汉字组成),为什么解析出来的是乱码啊,请达人帮助!
- DataReport报表程序在未安装vb的98下运行提示msdbrptr.dll版本过期?该怎么解决?
- 如何显示数据库中查到的记录数目?
- 请帮忙修改一下VB中的SQL语句
- [求助]关于服务器定时发送C盘剩余容量的程序
- TreeView控件不显示
- 请问哪里有下载MSDN的?
- mygis's q2) VB中有面版(Panel)吗?我要多个Panel可以在大Panel中可以上下拖动,怎么写?
SQL语句返回看看就比较明白了还有,建议一句写完sCmd = "insert into xshp (time,ele,water) values (" & _
"'" & txtTime & "'," & _
"'" & txtEle & "'," & _
"'" & txtWater & "')"
sCmd + " & txtTime & ", sCmd + " + txtEle + ",sCmd + " + txtWater + ")"
txtTime.Text = "2002/03/04"
txtEle.Text = "500"
txtWater.Text = "20"
Scmd = "insert into xshp (time,ele,water) values ("
Scmd = Scmd + "'" + txtTime + "',"
Scmd = Scmd + "" + txtEle + ","
Scmd = Scmd + "" + txtWater + ")"
Debug.Print Scmd
'结果:
insert into xshp (time,ele,water) values ('2002/03/04',500,20)
sCmd = "insert into xshp (time,ele,water) values (
'" & 参数 & "','" & 参数 & "'.........)
time 日期/时间
ele 自动编号
water 文本
-----------------------
其中ele 不能为自动编号最好采用以下的结构:
ID 自动编号
time 文本 (最好不要采用日期/时间 )
ele 文本
water 文本 sCmd = "insert into xshp (time,ele,water) values ("
sCmd = sCmd & "'" + txtTime + "',"
sCmd = sCmd & "'" + txtEle + "',"
sCmd = sCmd & "'" + txtWater + "')"