用access form做前台 oracle 作后台数据库现在维护需要新增加了一张表 通过access 下的vb 更新这张表 报Operation must use an updateable query 错误知道的大虾不要吝啬了
解决方案 »
- linux下安装完oracle11G怎么进入图形界面
- oracle远程用户的权限问题
- 【修正后】有关oracle查询语句性能的问题,附带执行计划。请有经验的朋友帮忙看看,谢谢。
- oralce8导出的dmp文件怎么导入到oracle9i里面阿?
- 在三层结构里,如果使用事务控制的例子
- 请教关于ORACLE调用java类的返回数据类型
- 这个SQL怎么写?
- 100分相送,征求意见!
- 谁知道哪里可以下载到oracle 9i啊,给提供个地址好嘛
- 急求救:我在linux安装oracle 8.0.5时,在复制软件时报relinking error!!
- 我想用java调用oracle触发器进行插入数据改怎么弄
- <long>
Dim szMinCapHold As StringSet ptrMinCaptbl = New ADODB.RecordsetWith ptrMinCaptbl
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenDynamic
.LockType = adLockReadOnly
End WithInsertMinCap = "YES"If IsNull(NewMinCapStartDate) Then
InsertMinCap = "NO"
MsgBox ("Value Required for MinCap Start Date")
DoCmd.GoToControl "NewMinCapStartDate"
ElseIf IsNull(NewMinCap) Then
InsertMinCap = "No"
MsgBox ("Value Required for Minimum Capacity")
DoCmd.GoToControl "NewMinCap"
ElseIf Not IsNull(NewMinCapEndDate) Then
If (NewMinCapEndDate <= NewMinCapStartDate) Then
InsertMinCap = "NO"
MsgBox ("End Date Must Be Greater Than Start Date")
DoCmd.GoToControl "NewMinCapEndDate"
End If
End If
If (InsertMinCap = "YES") Then
szMinCapHold = "Update cws_min_cap_history Set min_cap_end_date = '" & NewMinCapStartDate - 1 & "' Where min_cap_acct = " & ACCT_ID & _
" And min_cap_end_date is null"
ptrMinCaptbl.Open (szMinCapHold)
If (IsNull(NewMinCapEndDate)) Then
szMinCapHold = "Insert Into cws_min_cap_history (min_cap_acct,min_cap_effective_date,min_cap_end_date,min_cap_amount) values (" & _
ACCT_ID & ",'" & NewMinCapStartDate & "',NULL," & NewMinCap & ")"
Else
szMinCapHold = "Insert Into cws_min_cap_history (min_cap_acct,min_cap_effective_date,min_cap_end_date,min_cap_amount) values (" & _
ACCT_ID & ",'" & NewMinCapStartDate & "','" & NewMinCapEndDate & "'," & NewMinCap & ")"
End If
ptrMinCaptbl.Open (szMinCapHold)
NewMinCapStartDate = Null
NewMinCapEndDate = Null
NewMinCap = Null
DoCmd.Requery
End IfEnd Sub
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenDynamic
.LockType = adLockReadOnly
End With readonly貌似不能执行DML语句
我在ORACLE 下 表叫min_history 链接到ACCESS时 设成CWS_min_history CWS是用户名
在ACCESS下SELECT是可以执行的。 但UPDATE DELETE都不行
UPDATE报Operation must use an updateable query delete报 无法从指定的数据表中删除。
是链接ODBC时出了问题