SQLString = "create table " & tableName & " (序号 bigint primary key ,标段 varchar(10),监控点 varchar(20),日期 datetime,时间 char(10),图片 varchar(100))"
conn.Execute SQLString, adCmdText
SQLString = "insert into " & Trim(tableName) & " (序号,标段,监控点,日期,时间,图片) values('1', '" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
各位大侠,帮忙看看这两句话有什么错误,谢谢了!
conn.Execute SQLString, adCmdText
SQLString = "insert into " & Trim(tableName) & " (序号,标段,监控点,日期,时间,图片) values('1', '" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
各位大侠,帮忙看看这两句话有什么错误,谢谢了!
哪报错?我也不是在行
提示“-”附近有语法错误
让我很郁闷
conn.Execute SQLString, adCmdText
SQLString = "insert into [" & Trim(tableName) & "] (序号,标段,监控点,日期,时间,图片) values('1', '" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
顺便再请教一个问题
SQLString = "select * from Sysobjects where name='" + tableName + "'and xtype='U' "
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
Set rs = conn.Execute(SQLString)
If rs.RecordCount Then
Text1.Text = "表不存在"
SQLString = "create table [" & Trim(tableName) & "] (序号 bigint primary key,标段 varchar(10),监控点 varchar(20),日期 datetime,时间 char(10),图片 varchar(100))"
conn.Execute SQLString
SQLString = "insert into [" + Trim(tableName) + "] (序号,标段,监控点,日期,时间,图片) values('1', '" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
Else
Text1.Text = "表存在"
SQLString = "insert into [" + Trim(tableName) + "] (序号,标段,监控点,日期,时间,图片) values(' ' ,'" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
End If我上边的判断“表是否存在”,存在问题
望帮忙解决以下
无法来判断该表名是否存在
不知道该如何解决?
conn.Execute "select * from 表", adCmdText
if err.number<>0 then msgbox "错误,表不存在"
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
Set rs = conn.Execute(SQLString)
If rs.PageCount Then
Text1.Text = "表不存在"
On Error Resume Next
SQLString = "create table [" & Trim(tableName) & "] (序号 bigint primary key,标段 varchar(10),监控点 varchar(20),日期 datetime,时间 char(10),图片 varchar(100))"
conn.Execute SQLString, adCmdText
SQLString = "insert into [" + Trim(tableName) + "] (序号,标段,监控点,日期,时间,图片) values('1', '" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
rs.Update
Else
Text1.Text = "表存在"
SQLString = "insert into [" + Trim(tableName) + "] (序号,标段,监控点,日期,时间,图片) values(' ' ,'" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
End If
加了On Error Resume Next以后,能捕捉错误 但是只能插入两条信息,之后便终止了 还望高手继续赐教
Set rs = conn.Execute(SQLString)
If Not rs.EOF Then
Text1.Text = "表存在"
Else
Text1.Text = "表不存在"
SQLString = "create table [" & Trim(tableName) & "] (序号 bigint primary key,标段 varchar(10),监控点 varchar(20),日期 datetime,时间 char(10),图片 varchar(100))"
conn.Execute SQLString, adCmdText
End If
SQLString = "insert into [" + Trim(tableName) + "] (序号,标段,监控点,日期,时间,图片) values(' ' ,'" & Trim(biaoDuan) & " ','" & Trim(jianKongDian) & "','" & Trim(nowDate) & "','" & Trim(zhuaPaiTime) & "','" & Trim(singleFilePath) & "')"
conn.Execute SQLString, adCmdText
我改成这种方式,随后插入的时候 提示如下
[miscosoft][ODBC SQL Server][SQL Server]当IDENTITY INSERT 设置为OFF时,不能向表‘路通-路通院内’中的标识列插入显式值。
response.write "表不存在"
else
...
end if