Dim StrCon As String
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
StrSql = "INSERT INTO hyxx (" _
& " id,name,sex,hykmc,add,qt,photo,zjhm,sr,dwzy,email,time1)" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vip system\vip.mdb;Persist Security Info=False"
rs.Open StrSql, StrCon
为什么会提示语法错误,我想用INSERT语句将记录插入出ACCESS数据库中,怎么写
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
StrSql = "INSERT INTO hyxx (" _
& " id,name,sex,hykmc,add,qt,photo,zjhm,sr,dwzy,email,time1)" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vip system\vip.mdb;Persist Security Info=False"
rs.Open StrSql, StrCon
为什么会提示语法错误,我想用INSERT语句将记录插入出ACCESS数据库中,怎么写
解决方案 »
- 违反PRIMARM KEY约束
- 求XpressQuantumGrid Suite
- 随机函数重复的问题
- 应该在何时关闭Connect?
- 对Oracle的操作,这样有错吗?
- 我想在VB中关闭当前系统的IE,不知道该怎么操作?你们有用到过吗?
- data控件的recordCount问题
- 如何取得一个自定义类型需分配内存的大小~?
- VB6.0好像不支持officeXP的ACCESS,怎样才能支持?
- Move and Resize Controls at Runtime Like the VB IDE (updated 2002/07/11)
- 如何能在执行需时间较长sql语句的同时让进度条向前走,该怎么做??
- 问,如何改变 listview 的第一列的背景颜色? 从而与其它几列分开出来?
& "[id],[name],[sex],[hykmc],[add],[qt],[photo],[zjhm],[sr],[dwzy],[email],[time1])" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
完整的字符串如上。
字段类型都是文本型的。
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
语法错误,因改为
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
= "INSERT INTO hyxx (" _
& " id,name,sex,hykmc,add,qt,photo,zjhm,sr,dwzy,email,time1)" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vip system\vip.mdb;Persist Security Info=False"
rs.Open hyxx, StrCon
StrCon.Execute StrSql
Dim StrCon As String
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.RecordsetSet con = New ADODB.Connection
Set rs = New ADODB.Recordset
= "INSERT INTO hyxx (" _
& " id,name,sex,hykmc,add,qt,photo,zjhm,sr,dwzy,email,time1)" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vip system\vip.mdb;Persist Security Info=False"
rs.Open "SELECT * FROM hyxx", StrCon, adOpenKeyset, adLockBatchOptimistic, adCmdText
StrCon.Execute StrSql
Conn.Execute "Update 表 Set 字段1="数据",字段2="数据", Where 条件字段='" + text1.text + "'"
Con.Execute "Insert Into hyxx (" _
& " id,name,sex,hykmc,add,qt,photo,zjhm,sr,dwzy,email,time1)" _
& " Values('006','fureerle','男','1','1','1','1','1','1','1','1', '1') "
然後在程序的開始加上:
on error resume next
再將
rs.Open StrSql, StrCon
改為:
con.open StrCon
con.execute StrSql
msgbox Err.Description
這樣就可以清楚的看到出錯的信息了,當調試成功後,將on error resume next與msgbox語句刪除。