将text1~text5的内容作为一条记录插入到表中,数据库表的有三个字段是时间格式,两个是文本格式(其中一个是关键字),关键字的textbox肯定有输入内容,但是其他字段的textbox只要有一个缺省,就没法插入到表中,提示数据类型不匹配,请问该怎么解决?(数据库中除关键字外都已经设了可以为空的条件)
各位大虾帮忙!
各位大虾帮忙!
解决方案 »
- VB qq消息监控
- 如何访问远程access数据库?
- 解释!!在线等待!!
- 个人网站已经开通,欢迎大家下载类似OUTLOOK的软件,提供DEMO和部分代码!
- toolbar做的下拉菜单应如何加快捷键,用加快捷键可展开此菜单
- dll技术难题 急(100分)
- 小马哥,分页怎么还是不行啊?帮忙再给看看?
- 有谁做过调用word、excel等的东东,要求类似OLE控件风格,但菜单能在控件内部的.
- 请教各位大虾一个问题,怎样锁定指定窗口以外的输入?
- 有关LDAP,有没人用过Activex LDAP Client 或其他的LDAP Client?
- 请教 在VB代码中修改登录密码怎么会出现这种情况?在线等
- 如何让运行的程序定时结束?
insert into 表 values('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "')"
Dim cnn As ADODB.Connection
Dim strcnn As String
Dim rs As ADODB.Recordset
Dim rs_db As ADODB.Recordsetstrcnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\计划管理系统.mdb;Persist Security Info=False"
Set cnn = New ADODB.Connection
cnn.Open strcnn
strsql_db = "select * from table"
cnn.Execute strsql_db
Set rs_db = New ADODB.Recordset
rs_db.Open strsql_db, cnn, adOpenKeyset, adLockOptimistic
do while not rs_db.eof
rs_db.addnew
rs.Fields("jh_dj") = text1.text & ""
或者
if isnull(rs.fields("jh_dj")) then
rs.fields("jh_dj")=""
else
rs.Fields("jh_dj") = text1.text
end if
rs_db.update
rs_db.movenext
loop
Private Sub Command1_Click()
strDSN = "DSN=合同跟踪"
CONN.Open strDSN
Dim rs1 As New Recordset
Dim strSql As String, strTemp As String, i%, lowLimit As Long, upLimit As Long
lowLimit = CLng(Mid(Text1.Text, 5))
upLimit = CLng(Mid(Text8.Text, 5))
For i = lowLimit To upLimit
strTemp = ""
strTemp = Left(Trim(Text1.Text), 4) '从Text1.Text中取出到"05电",根据你的具体情况来修改
strTemp = strTemp & Format(i, "0000") '0的个数具体根据你的主键的名称来定
strSql = "insert into 标准委派 values('" & strTemp & "','" & IIf(Text2.Text = "", "", "#" & Text2.Text & "#") & "','" & IIf(Text3.Text = "", "", "#" & Text3.Text & "#") & "','" & Text4.Text & "','" & IIf(Text5.Text = "", "", "#" &
----------------
Text5.Text & "#") & "','" & Text6.Text & "','" & Text7.Text & "')"
-----------
rs1.CursorLocation = adUseClient
rs1.Open strSql, CONN, adOpenKeyset, adLockOptimistic
Next
End Sub
rs1.Open "Select Top 1 * from 标准委派",CONN,adOpenKeyset,adLockOptimistic
For i = lowLimit To upLimit
strTemp = ""
strTemp = Left(Trim(Text1.Text), 4) '从Text1.Text中取出到"05电",根据你的具体情
况来修改
'不用insert into 语句,这里用AddNew语句:
rs1.AddNew
rs1(0)=strTemp
rs1(1)=Text1.Text
rs1(2)=Text2.Text
rs1(3)=Text3.Text
rs1(4)=Text4.Text
If IsDate(Text5.Text) then rs1(5)=CDate(Text5.Text)
If IsDate(Text6.Text)then rs1(6)=CDate(Text6.Text)
If IsDate(Text7.Text) then rs1(7)=CDate(Text7.Text)
rs1.UpDate
Next
End Sub
values("& iif(not isdate(text3.text),"NULL","#" & text3.text & "#") &")"
请问该怎么写for循环的删除和修改、刷新??
For i = lowLimit To upLimit
strTemp = ""
strTemp = Left(Trim(Text1.Text), 4) '从Text1.Text中取出到"05电"
strTemp = strTemp & Format(i, "0000")
strSql = "DELETE FROM 营业资料签收 WHERE 生产工号='" & strTemp & "')"
CONN.Execute (strSql)
Next
strSql = "DELETE FROM 营业资料签收 WHERE 生产工号='" & strTemp & "'"
例如:text1.text=Data1.Recordset.Fields("abc").Value & ""