社区
数据库相关
帖子详情
用ODAC的OraQuery不能修改记录,提示Cannot modify a read-only dataset
yanghanks2009
2009-12-21 06:03:33
请教高手:
用ODAC的OraQuery.edit,提示Cannot modify a read-only dataset
用的是TDataSource或是OraDataSource
OraQuery的ReadOnly属性也改成了False还是不行
用户有写权限,表也能写入.
谢谢各位高手啦!
...全文
260
3
打赏
收藏
用ODAC的OraQuery不能修改记录,提示Cannot modify a read-only dataset
请教高手: 用ODAC的OraQuery.edit,提示Cannot modify a read-only dataset 用的是TDataSource或是OraDataSource OraQuery的ReadOnly属性也改成了False还是不行 用户有写权限,表也能写入. 谢谢各位高手啦!
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
3 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
wxsan
2009-12-23
打赏
举报
回复
你可以加入qq高级群:9642802,详细的问一下!
yanghanks2009
2009-12-21
打赏
举报
回复
[Quote=引用 1 楼 wxsan 的回复:]
为了安全及效率,OraQuery不能直接通过dbgrid改数据,(如果设localupdate=true,只会更新本地数据而非服务器)
你可设
OraQuery1.UpdateSQL为
UPDATE t
SET
A = :A,
B = :B,
WHERE
ROWID = :OLD_ROWID
这样就可以更新服务器上的数据了
你也可以在OraQuery1的Macros来处动生成所有的Update/insert/delete...的SQL
[/Quote]
我要进入DBGridEh,修改数据后在保存。
如果设了LocalUpdate:=True ,就能进入DBGridEh修改数据了吗?
修改过哪些记录DBGridEh知道吗?
wxsan
2009-12-21
打赏
举报
回复
为了安全及效率,OraQuery不能直接通过dbgrid改数据,(如果设localupdate=true,只会更新本地数据而非服务器)
你可设
OraQuery1.UpdateSQL为
UPDATE t
SET
A = :A,
B = :B,
WHERE
ROWID = :OLD_ROWID
这样就可以更新服务器上的数据了
你也可以在OraQuery1的Macros来处动生成所有的Update/insert/delete...的SQL
DevArt
ODAC
8.6.11(17-Dec-2012) Only Source
DevArt
ODAC
8.6.11(17-Dec-2012) Only Source
ODAC
9.3 Full Source D7-XE6
Ora
cle Data Access Components (
ODAC
) is a library of components that provides native connectivity to
Ora
cle from Delphi, C++Builder, Lazarus (and Free Pascal) for 32-bit and 64-bit Windows, Mac OS X, Linux, and FreeBSD platforms. The
ODAC
library is designed to help programmers develop faster, cleaner and more native
Ora
cle database applications.
ODAC
, a high-performance and feature-rich
Ora
cle connectivity solution, is an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver. It provides both possibility of connection to
Ora
cle by means of native
Ora
cle data access and direct access to
Ora
cle without
Ora
cle Client. The
ODAC
library is actively developed and supported by the Devart Team. If you have questions about
ODAC
, email the developers at
odac
@devart.com or visit
ODAC
online at http://devart.com/
odac
/
ODAC
9.2 Full Source D7-XE5
Ora
cle Data Access Components (
ODAC
) is a library of components that provides native connectivity to
Ora
cle from Delphi, C++Builder, Lazarus (and Free Pascal) for 32-bit and 64-bit Windows, Mac OS X, Linux, and FreeBSD platforms. The
ODAC
library is designed to help programmers develop faster, cleaner and more native
Ora
cle database applications.
ODAC
, a high-performance and feature-rich
Ora
cle connectivity solution, is an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver. It provides both possibility of connection to
Ora
cle by means of native
Ora
cle data access and direct access to
Ora
cle without
Ora
cle Client. The
ODAC
library is actively developed and supported by the Devart Team. If you have questions about
ODAC
, email the developers at
odac
@devart.com or visit
ODAC
online at http://devart.com/
odac
/
ODAC
4.5.2.19
Ora
cle Data Access Components08-Oct-03 New features in
ODAC
4.50-------------------------------------------------- - XMLTYPE datatype support added - WideString support added to work with Unicode character data - Transparent Application Failover support addedT
Ora
XMLT
Ora
XMLFieldT
Ora
Param property AsXML: T
Ora
XML;TBlob property IsUnicode: boolean;T
Ora
SessionOptions property UseUnicode: boolean;TFailoverStateTFailoverTypeTFailoverEventT
Ora
Session property OnFailover;TLobTypeT
Ora
Lob procedure CreateTemp
ora
ry(LobType: TLobType);T
Ora
Table procedure EmptyTable;
odac
10 for xe 10.3
ODAC
直接使用
Ora
cle 调用接口 (OCI). OCI 是一种允许应用程序开发人员使用第三方开发语言存取
Ora
cle数据服务器的过程或函数以及控制所有的SQL语句执行状态的应用程序接口(API)。OCI 通过一个动态运行库(
ORA
*.DLL)提供了一个标准的数据库存取库及函数,以在应用程序中建立连接。也可以使用
ODAC
的Net选项而无需在客户机上安装
Ora
cle客户端来连接到
Ora
cle.在这种情况下,
ODAC
仅需要TCP/IP协议的支持,从而可以创建真正的、最小的数据库应用程序。 与使用BDE开发
Ora
cle C/S(客户/服务器)应用程序不同的是,BDE
不能
存取
Ora
cle的一些特殊功能,
不能
使用更多的资源,
不能
高速处理数据,而且不定期有麻烦的应用程序分发以及管理。
数据库相关
2,495
社区成员
88,444
社区内容
发帖
与我相关
我的任务
数据库相关
Delphi 数据库相关
复制链接
扫一扫
分享
社区描述
Delphi 数据库相关
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章