在插入记录时,我想先判断记录是否已经存在。
Dim conn As New ADODB.Connection
Dim connstr As String
Dim objrs As New ADODB.Recordset
Dim bianhao As String
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=dossier trustee ;Data Source=IP"
conn.Open connstr
objrs.Open "select bianhao from charge where bianhao = '" & bianhao & "'", conn, adOpenStatic, adLockReadOnly, adCmdText
譬如我想以bianhao进行查询,然后根据查询结果确定是否插入,若已有记录则提示不能插入。问题是不知怎么写。请大家帮忙
Dim conn As New ADODB.Connection
Dim connstr As String
Dim objrs As New ADODB.Recordset
Dim bianhao As String
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=dossier trustee ;Data Source=IP"
conn.Open connstr
objrs.Open "select bianhao from charge where bianhao = '" & bianhao & "'", conn, adOpenStatic, adLockReadOnly, adCmdText
譬如我想以bianhao进行查询,然后根据查询结果确定是否插入,若已有记录则提示不能插入。问题是不知怎么写。请大家帮忙
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货