BDE 的有缓存更新的设计,可以自己获得字段缓存的值;ADO 如何实现?有什么好的组件吗??最好给我提供一个例子,我得从BDE转到ADO ,急需这方面的参考!谢谢!另外,ADO 的方法我晓得一个,就是用事务锁定表,然后用静态光标可以实现,但是这样老是错误百出,基本上出错率是20%以上;请高手帮帮忙,解决小弟燃眉之急!分不够另开帖子再加,我一直提问都是100分以上,但能解决的帖子少只又少,所以这帖不高,但我保证解决问题理解加分!
解决方案 »
- 如何双击服务程序EXE文件自动安装或启动运行!
- 请问这段代码有问题吗?
- 如何在stringgrid中动态加载图片
- 在程序里如何对word文档的编辑?
- 各位高手请帮帮忙!后台FTP程序如何实现?急!急!
- 太奇怪了,我的delphi装上fastreport后,插上网线启动速度就很慢,拔下网线就很快!
- 请问如何让DBGrid中的某一行不显示
- 在D中怎么实现向导精灵式的界面?
- 大家能否看下
- delphi and lotus notes
- 我从csdn上面保存了一些xml格式的网页在电脑上,怎么打开啊,需要在论坛上哪里下载个什么包?我给忘了
- 组件事件问题:Assigned(FOnReceiveData)=false 怎么办?
LockType := ltBatchOptimistic;保存時:
AdoQuery1.UpdateBatch
to DongXF(孔雀东南飞) :谢谢指路;有没有办法判断数据是Insert 还是Update 还是Delete 的?还有数据类型验证 ?bde 的可以这样搞,因为单据都是bde的,现在要做成ado的,很多地方感觉是障碍
更新用AdoDataset.UpdateBatch
... //数据在新增状态if adoquery1.State = dsEdit then
... //数据在编辑状态
dsBrowse Data can be viewed, but not changed. This is the default state of an open dataset.
dsEdit Active record can be modified.
dsInsert The active record is a newly inserted buffer that has not been posted. This record can be modified and then either posted or discarded.
dsSetKey TClientDataSet only. Record searching is enabled, or a SetRange operation is under way. A restricted set of data can be viewed, and no data can be edited or inserted.dsCalcFields An OnCalcFields event is in progress. Noncalculated fields cannot be edited, and new records cannot be inserted.
dsFilter An OnFilterRecord event is in progress. A restricted set of data can be viewed. No data can edited or inserted.
dsNewValue Temporary state used internally when a field component抯 NewValue property is accessed.
dsOldValue Temporary state used internally when a field component抯 OldValue property is accessed.
dsCurValue Temporary state used internally when a field component抯 CurValue property is accessed.dsBlockRead Data-aware controls are not updated and events are not triggered when moving to the next record.
dsInternalCalc Temporary state used internally when values need to be calculated for a field that has a FieldKind of fkInternalCalc.
dsOpening DataSet is in the process of opening but has not finished.
好了,不用它,希望这里的人解决实际问题时能多提供几种方案。