关于oracle的addnew问题,大家看看
cslf 2004-11-18 03:21:56 表结构如下:
CREATE TABLE JTDAMS.JT_DICT1
(
ID CHAR(10),
DH CHAR(10) NOT NULL,
MZ CHAR(10) NOT NULL,
LX CHAR(10) NOT NULL,
FLAG CHAR(1) DEFAULT 'N' NOT NULL,
CONSTRAINT PRI_JT_DICT1 PRIMARY KEY (DH, LX)
)
/
vb测试代码如下:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub Command1_Click()
qzh = "121"
qzm = "qwqw"
rs.CursorLocation = 3
sqlstr = "select * from jt_dict1"
rs.Open sqlstr, conn, 1, 3
rs.AddNew
rs("dh") = CStr(qzh)
rs("lx") = "#QZ#"
rs("mz") = CStr(qzm)
rs.Update'执行到这里死机。
End Sub
说明:win2000+vb6+sp6+oracle815。上面的例子在access2000里正常,或者用execute也正常。用asp执行类似代码,iis马上死掉。