后面加上 where p_n<>chk_altpn
解决方案 »
- VB treeview 控件里面怎么实现修改了某个子节点使它重新排序??
- 求助!如何让自己编写的宏运行EXCEL自己内置的宏?
- VB连接数据库问题
- 设计器Data Environment
- VB程序中汉字如何在英文/日文系统中显示正确
- 如何在VB中操作BLOB(二進制大文本)對象?
- 求助~~在线等EXCEL如何连接SQL,并按条件查询
- 低价出售Component One 8.0 VB/VC 豪华编程套件
- vb 实现一个按钮立体效果,我是新手,还请多指教。谢谢!!!
- 希望你的心能动一动,做个好心人,帮帮我????
- win98风格的MDI怎样才能才成变得像XP风格的MDI,分数不够我可以加。
- 我现在有一个小问题要求助于各位,请大家帮忙呀?
If Not chk_altpn = Trim(stock_Record!P_N) Then
WORK_Connection.Execute "INSERT INTO supplier_stock (qref,p_n) VALUES ('" + M_QREF + "','" + chk_altpn + "')"
stock_Record.MoveNext
End If
End If改为
WORK_Connection.Execute "INSERT INTO supplier_stock (qref,p_n) VALUES ('" + M_QREF + "','" + chk_altpn + "') " + "where p_n<>chk_altpn"INSERT语句的范围本来就是整个表
在第一条记录比较时就是not chk_altpn=trim(stock_record!p_n),当然是继续执行下面的insert语句了。
我想从表stock第一个记录开始找到最后一个,如有p_n不等于chk_altpn,则插入新纪录!啥写?!
我用上面的,但不能插入!啥办
试试这个。Set stock_Record = New ADODB.Recordset
stock_Record.Open "SELECT * FROM supplier_stock WHERE P_N='" & chk_altpn & "'", WORK_Connection, 1, , adCmdUNDOWN
stock_Record.Requery
IF STOCK_RECORD.EOF AND STOCK_RECORD.BOF THEN
WORK_Connection.Execute "INSERT INTO supplier_stock (qref,p_n) VALUES ('" & M_QREF & "','" & chk_altpn & "')"
END IF
Set WORK_Connection = New ADODB.Connection
WORK_Connection.Open "Provider=SQLOLEDB.1;Password=ets2001;Persist Security Info=True;User ID=sa;Initial Catalog=ETS;Data Source=" + Server_Name
Dim stock_Record As ADODB.Recordset
Set stock_Record = New ADODB.Recordset
M_QREF=label1.caption
chk_altpn=labe2.caption
stock_Record.Open "SELECT * FROM supplier_stock WHERE P_N='" & chk_altpn & "'", WORK_Connection, 1, , adCmdUNDOWN
stock_Record.Requery
IF STOCK_RECORD.EOF AND STOCK_RECORD.BOF THEN
WORK_Connection.Execute "INSERT INTO supplier_stock (qref,p_n) VALUES ('" & M_QREF & "','" & chk_altpn & "')"
END IF