社区
数据库相关
帖子详情
delphi出错:dataset not in edit or insert mode怎么办?
oatiy
2009-10-19 04:15:12
如何修改dbgrid里的数据啊
...全文
735
5
打赏
收藏
delphi出错:dataset not in edit or insert mode怎么办?
如何修改dbgrid里的数据啊
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
5 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
oatiy
2009-10-19
打赏
举报
回复
2楼非常正确,问题里面解决。其他老师,也谢谢了
火龙岛主
2009-10-19
打赏
举报
回复
判断状态后再保存。
if adoquery1.state in [dsEdit, dsInsert] then
adoquery1.post;
风之谷
2009-10-19
打赏
举报
回复
不在修改或插入状态下 进行编辑货插入操作
table1.edit; or table1.insert;
table1.state=dsedit,table1.state=dsinsert
bdmh
2009-10-19
打赏
举报
回复
你代码问题,修改时
adoquery1.Edit;
adoquery1.FieldByName('myname').AsString := '中国';
adoquery1.Post;
yufu2000
2009-10-19
打赏
举报
回复
在编辑前测试数据集状态,大概如下,不在编辑状态的话,先进入编辑状态
if table1.status<>'edit' then
table1.edit;
unigui0.83.5.820
0.83.5.820 +---------------------------------------------------------------------------------------- - 0000796: DBGrid: Render bug when Column color is clWindow and project is created with 0.82 - 0000795: Grid: Cell background color change poor render performance - 0000791: UniDBGrid, UniStringGrid: Option to disable custom renderer to speed-up render time. 0.83.4.819 +---------------------------------------------------------------------------------------- - 0000789: UniDBComboBox, UniDBListBox:
Edit
mode
is not set when changed - 0000784: TUniStringGrid: Data not restored after decreasing/increasing Row count - 0000788: Bug in Grid Row/Col translation - 0000787: UniDBGrid: Broken CellSelect behavior - 0000786: MessageDlg and mtInformation bug. 0.83.2.817 +---------------------------------------------------------------------------------------- - 0000781: UniDBGrid: Row selection bug when no data is in
dataset
- 0000779: UniStringGrid: OnClick event implemented - 0000780: UniDBGrid: OnCellClick bug - 0000777: TUniDBGridColumn.ReadOnly property - 0000778: UniStringGrid: Assigning HTML content to cells - 0000776: UniDBLookUpXXX: ListSource cursor position does not follow Lookup value - 0000773: UniDBGrid: Column.Title.Font/Color - 0000771: UniDBGrid: Column.Font property - 0000772: UniDBGrid: Column.Color property - 0000775: UniFont: [fsUnderline, fsStrikeOut] implemented - 0000774: TUniStringGrid: OnDrawCell event - 0000769: UniDBGrid: Row position is ignored if row is immediately changed after a call to Open() - 0000673: UniDBGrid: OnDrawColumnCell event - 0000768: Better "ext\" folder translation - 0000766: TUniCalender.FirstDayOfWeek property - 0000767: TUniDateTimePicker.FirstDayOfWeek property - 0000765: UniImage: Bug when both Proportional and Stretch are true - New Demo: DrawCell 0.83.1.812 +---------------------------------------------------------------------------------------- - 0000764: KeyValue property for UniDBLookupXXX - 0000763: UniDBGrid doesn't handle T
DataSet
.Refresh() - 0000762: UniListBox and Items.Delete bug - 0000760: UniDBLookupXXX: KeyField value submit bug - 0000761: Uni
Edit
and KeyXXX event bug - 0000759: UniDBLookupXXX: KeyField value problem 0.83.0.811 +---------------------------------------------------------------------------------------- - 0000756: MenuItem.Enabled property - 0000755: MenuItem.Visible not working in web
mode
. - 0000754: UniPageControl: UniTabSheet design time
edit
or - 0000661: enabled/disabled property of TUniToolbarButton - 0000751: UniRadioButton value submission bug - 0000749: Changing ReadOnly := False in UniDateTimePicker & UniDbLookupComboBox raises AV - 0000721: Set ReadOnly := False on UniDB controls on runtime raises AV - 0000445: Customizable Timeout and Terminate pages. - 0000558: Customizable End of Session - 0000748: Field property for DB aware controls - 0000747: AV when trying to access the property TUniDB
Edit
.Field - 0000746: SessionManager: Bug when there is an Exception in session.Destroy - 0000745: TUniMemo.Clear bug - 0000740: UniTreeView: Node.Data not implemented - 0000744: UniDBMemo.Lines property - 0000743: UniDBMemo.Text porperty is not published - 0000739: UniTreeView: Items.Clear not implemented - 0000736: UniPageControl: Runtime assignment of OnChange event - 0000737: UniDBLookupXXX: Bug when there is " in string - 0000738: UniTreeView: GetFirstNode not implemented - 0000485: TUniButton renders non-themed! - 0000698: Toolbar Button Image/Text alignment - 0000732: TUniPageControl: Bug while setting designtime ActivePage - 0000716: Change Tab title in runtime - 0000507: Direct filename or image URL for TUniImage - 0000733: TUniScreenMask with a TUniPageControl does not work - 0000734: AutoScroll property for UniHTMLFrame - 0000680: The Alignment taRightJustify of a TUniDBGrid column - 0000610: TabOrder for dynamically created controls - 0000627: Unpublish OnChange in TUniComboBox web
mode
- 0000601: New Event in ServerModule to handle exceptions - 0000728: Disabled Uni
Edit
does not receive values assigned with Control.Text := Value - 0000720: Tag property for DBGrid Columns - 0000723: DBGrid: numeric column is not aligned to right - 0000722: Setting Align := alCenter on DBGridColumns does not work - 0000715: OmniHTTPD and UniGUI ISAPI - 0000724: Runtime assignment for Align/Alignment property of UniDbGrid column - 0000714: UniDBGrid: Implement StripeRows property - 0000712: raise error if Form owner is not either TUniGUIApplication or TApplication - 0000609: TUniTimer: Attach to TUniScreenMask - 0000703: TUniDBLookUpxxx bug when datasource and datafield are not assigned - 0000731: Broken TabOrder in 0.82.0 - 0000708: UniGroupBox: Caption assignment when created dynamically - 0000706: Uni
Edit
: Password char bug - 0000707: UniSplitter: ScreenMask doesn't work - 0000709: Changes in Form layout not reflected correctly - 0000437: AV when creating inherited forms when no projectgroup is available - 0000413: Maximized ExtWindow can't return to normal size - 0000697: UniPanel: Caption Alignment - 0000696: UniPanel: Caption - 0000699: UniPageControl: TabSheet is visible when TabVisible=False - New Demo: CustomException - New Demo: UniImage 0.82.1.804 +---------------------------------------------------------------------------------------- - 0000630: Big images in buttons - 0000692: Runtime creation and modification of DBLookup components - 0000693: UniDBLookup bug - 0000695: UniDBGrid: Broken OnCellSelect in 0.82.0 0.82.0.803 +---------------------------------------------------------------------------------------- - 0000668: UniDBGrid with data Memory leak - 0000686: New TUniHTMLFrame Component - 0000570: New TUniDBLookupComboBox and TUniDBLookupListBox Components - 0000689: CustomFiles property for ServerModule to add custom CSS and JS files - 0000688: Bug in installer Environment setter - 0000687: "Script" property for TUniForm for adding Custom JS - 0000665: Compatibility with multiple IP systems - 0000685: UniDBGrid: Ellipsis in first column bug (IE) - 0000690: UniDBGrid: OnTitleClick event - 0000684: Uni
Edit
: Text alignment - 0000683: UniScreenMask bug with Maximized Form and mfPage set - 0000682: UniStringGrid: OnSelectCell bug - 0000679: Common DB Controls bug - 0000641: UniTabSheet.TabVisible property - 0000678: Core bug: Setting Align property at runtime - 0000677: Hiding or showing controls doesn't apply alignment/anchoring correctly - 0000675: Setting position of a UniTrackbar at run time - 0000671: UniDBListBox:
Dataset
is not set to
edit
mode
after change - New Demo: DBLookup - New Demo: HTMLFrame - New Demo: Basic jQuery 0.81.2.801 +---------------------------------------------------------------------------------------- - TUniScreeMask issue with borderless MainForm - Installer: Bug resolved when selected
Delphi
version is not installed - XE DCU files compiled with Update 1 - Borderless MainForm bug fix 0.81.1.800 +---------------------------------------------------------------------------------------- - UniDBGrid: Critical bug in ISAPI
mode
- Critical bug in AssignGlobalDateParams 0.81.0.798 +---------------------------------------------------------------------------------------- - New Component UniDBText - Ability to create a windowless borderless MainForm - UniTreeView: Node dynamic add/delete support - UniTreeView: Several Memory leak issues - UniDBGrid: DBGrid.Column.Visible bug - PageControl: Render problem in invisible tabs - TUniListBox: Items are not rendered if placed on UniPageControl invisible Tab - ISAPI: Bug when pathInfo contains Unicode chars - TUniLabel Text alignment - UniDBGrid: _OnDataLoaded may be called before Grid is rendered - UniPageControl: TabIndex doesn't return correct index - UniComboBox in hidden TabPage bug in Chrome browser - UniApplication: New ClientInfo property - New Demo: TreeView - New Demo: ClientInfo - New Demo: Windowless 0.80.2.796 +---------------------------------------------------------------------------------------- - TUniChart moved to UniGUIEx package - TUniSplitter: Runtime create problem - Memory Leak in TUniForm 0.80.1.794 +---------------------------------------------------------------------------------------- - Apache web server and CoInitialize issue - UniSplitter Color in Web
mode
- UniSplitter broken and Ext JS 3.3.0 issue - New Component: TUniChart Component first preview - UniDateTimePicker: OnEnter, OnExit Events - UniGroupBox: CSS frame margin bug (IE) - TUniLabel: AutoSize problem - UniFileUpload: several changes - UniFileUpload: File names containing Unicode chars are returned correctly - Change color of label at runtime - Various runtime property assignment bugs - DataStores and AutoDestroy - Changing Server Port at runtime. - TabOrder and TabStop for Web - Upgraded to Latest Ext JS release (3.3.0) - UniTrackBar: Set Max at runtime - UniDBGrid:
DataSet
After
Edit
: Reload grid only when needed - New Demo: Chart Demo 0.79.1.788 +---------------------------------------------------------------------------------------- - UniRadioGroup: Render bug when control is disabled - Style:"color:#000000" in FontStyle bug - FileUpload bug - New TUniScreenMask component - Add startup "Loading..." message - Server Bindings property implemented - OwnerForm.IsDestroying: When owner is TUniFrame - DB Controls: Check IsDestroying - Allow suppressing "Ajax" and "Object not found" Errors - Syn
Edit
: some unicode widechars cause problem in D2009+ (removed) -
Insert
Control/RemoveControl internal bug - TUniToolButton: Dynamic creation - UniDBGrid: Grid row doesn't change when table row changes - UniDBGrid: Master/Detail Support - uniDBGrid: Assigning ReadOnly property in runtime - uniDBGrid: Assigning Options.dg
Edit
ing property in runtime - UniForm: Event OnScreenResize implemented - UniForm: Event OnResize implemented - UniApplication: ScreenWidth, ScreenHeight Property - UniTreeView: AutoExpand Property - A mean to determine dimensions of the browser window - ExtPascal: Param Place Holders problem - TreeView: Full Tree load on first call - UniTreeView: TTreeNode.MakeVisible implemented - uniDBGrid: After opening grid row is set to real
Dataset
cursor location - UniGroupBox: Caption not visible bug - UniRadioGroup: Caption not visible bug - UniRadioButton: OnClick event implemented - UniLabel: Allow HTML Content - ServerModule: Implement Temp Folder Property - Unicode bug in ISAPI module - New Demo: Screen Size - New Demo: UI Mask - New Demo: Download Demo 0.78.0.783 +---------------------------------------------------------------------------------------- - Lots of changes and bug fixes in Unicode and codepage handling - Ajax Core: Queue process improvement - Don't respond Alert() to data requests - UniExtTimer.Stopall: check for null object - ExtJS: Test for "undefined" before destroy - UniDBGrid bug: FColumnsChanged is True after ConfigureExtColumns - A customized version of Indy included (10.5.7) - Unicode data transfer and IIS ISAPI bug - TUniTimer runtime enable bug - ExtPascal: StrToJS problem: Strings containing %nn - Unicode conversion bug - UniToolBar: ShowCaptions implemented - Inherited form Reader bug -
Delphi
XE: Unicode conversion problem - UniPageControl: Dynamic create: Initial ActiveTab bug? - New Demo: Unicode Demo (for D2009 and later) 0.77.1.781 +---------------------------------------------------------------------------------------- - D2009+ UniFrame creation problem - Other Project Wizard related bugs fixed 0.77.0.780 +---------------------------------------------------------------------------------------- - uni
Edit
, uniDB
Edit
: CharEOL property added - Buttons: Click Method implemented - New WebOptions property for uniDBGrid (Paged, PageSize) - CodeMirror: Missing Pascal keywords added - New Demo: CharEOL Demo 0.76.0.779 +---------------------------------------------------------------------------------------- -
Delphi
XE Support - uniTreeView: AddChild() Implemented - uniTreeNode: IsFirstNode() Implemented - ExtPascal: VarToJSON: WideString conversion bug - uniTreeView: D2009+ resource compatibility issue - In web
mode
some controls aren't assigned a default Width/Height - In StrToJs
is not interpreted correctly. - UniSyntax
Edit
: CodePress replaced with CodeMirror (CodePress files removed from installer) - Standalone server will display application name - Control parent assignment bug when parent is TUniForm - UniRadioGroup: runtime OnClick event assignment bug - Other minor changes and fixes - New Demo: SQL Demo ( Requires DBISAM http://www.elevatesoft.com/download?category=dbisam ) 0.75.0.777 +---------------------------------------------------------------------------------------- - Internal Bug fix in TUniExtWinControl.SetComponentsLoaded() - Internal Bug fix in TUniExtWinControl.RemoveControl() - Uni
Edit
: MaxLength Property implemented - UniSplitter improved - Several bug fixes in UniSplitter - UniSyntax
Edit
improved - UniSyntax
Edit
bug fixes - Now Syn
Edit
Packages are included in the installer 0.74.0.774 +---------------------------------------------------------------------------------------- - New: Inheritable Frames - New: Inheritable DataModules - New: In "Object Inspector" properties that are not implemented in web
mode
are displayed in gray - Bug in inherited form implementation - Improved exception handling - UniDBGrid: OnCellClick passes wrong Column - TUniDBGridColumn: Implement Field public property - When wsMaximized some components may render in wrong placed (IE8) - TUniForm: OnDestroy() implemented - DB Controls: Dynamic DataSource assignment - Workaround for WindowState wsMaximized problem 0.73.0.770 +---------------------------------------------------------------------------------------- - New: Service Application implemented - Async request
mode
is default
mode
now - Several Bug fixes and changes in AJAX Core - DB Controls: Internal improvements and fixes 0.72.2.767 +---------------------------------------------------------------------------------------- - Several internal core changes and bug fixes 0.72.1.766 +---------------------------------------------------------------------------------------- - Sync
mode
partially disabled 0.72.0.765 +---------------------------------------------------------------------------------------- - New Component TUniFileUpload - KeyEvents internal bug - TUniDBNavigator: VisibleButtons Property implemented - TUni
Edit
: Clear Method implemented - Bug: Showing a Window in another Window's OnShow event - uniMainMenu: Top level menus OnClick event not implemented - KeyEvents Bug - AJAX Core problem - Now Close tool button on Window can be removed - New Sync/Async
mode
s implemented - Bug: Calling
DataSet
.Refresh in OnClose event may raise Ajax Error - When no project is active creating a new Form or DataModule fails - TUniImage: PNG Images are not shown in Web
Mode
- PNG/GIF type Images will not be converted to other formats - AV when calling FullExpand method of TUniTreeView - TUniTreeView: FullCollapse implemented - Internal Bug in DB Control DataChange - TUniForm: OnActivate implemented - Bug in ShowMessage - New Demo: FileUpload 0.71.0.760 +---------------------------------------------------------------------------------------- - New Component TUniDBListBox - New Component TUniDBComboBox - New Component TUniURLFrame - Form Inheritance implemented - OnEnter and OnExit Events implemented - TUniRadioGroup: OnClick Event implemented - Bug in UniTabControl - URL Parameters Implemented - New method: UniApplication.Terminate() - TUni
Edit
CharCase property implemented - TUniDateTimePicker "Visible" bug fixed - SetFocus bug fixed - TuniRadioGroup: ItemIndex implemented - TUniPageControl: Property ActivePage implemented - TUniListBox: ItemIndex bug fixed - DB Controls: internal Bug fixed - StandAloneServer Control Panel imporved - Improved Project Wizard - UniDateTimePicker: OnChange event implemented - Forms divided into two categories: Application Forms and normal Forms - KeyDown, KeyUp, KeyPress implemented - ExtRoot bug in ServerModule fixed - ClientHeight problem in XP theme fixed - 4 new demos: URLFrame, FormInheritance, Dynamic, URLParameters 0.70.0 +---------------------------------------------------------------------------------------- First Beta
DevExpress VCL 13.2.5 D7-DXE6 FullSource
What's New in 13.2.5 (VCL Product Line) New Major Features in 13.2 What's New in VCL Products 13.2 Feature Highlights To learn about feature highlights in this version, please refer to the following page: Feature Highlights in 13.2.5 (VCL Product Line) Known Issues To learn about known issues in this version, please refer to the following page: Known Issues in 13.2.5 (VCL Product Line) The following sections list all minor and major changes in DevExpress VCL 13.2.5. Note that products, controls and libraries which aren't mentioned in the list below are included in the unified installer for compatibility, but have not been updated. Enhancements and Updates •New Features/Updates •ExpressVerticalGrid Suite •Express
Edit
ors Library •Resolved Issues •ExpressBars Suite •ExpressDocking Library •ExpressLayout Control •ExpressPageControl •ExpressPrinting System •ExpressQuantumGrid Suite •ExpressQuantumTreeList Suite •ExpressScheduler Suite •ExpressSkins Library •ExpressTile Control •ExpressVerticalGrid Suite •ExpressWizard Control •Express
Edit
ors Library •ExpressLibrary •Installation (VCL) New Features/Updates ExpressVerticalGrid Suite •S173543 - Introduce a property providing access to the FNewLoad
Mode
field declared in the TcxCustomVerticalGrid class Common Libraries Express
Edit
ors Library •S173677 - Documentation - Add a note that resizing an alert window via the standard window size API (properties or methods inherited from TdxAlertWindow ancestor classes) is not recommended Resolved Issues ExpressBars Suite •Q584524 - Ribbon - QAT doesn't display the double arrow if the Ribbon control's PopupMenuItems set does not include items •Q581962 - Ribbon - Switching between maximized MDI child windows using the Ctrl+F6 key combination doesn't make them occupy the entire main window if Ribbon controls on these windows are merged •Q468576 - Switching a floating toolbar's Visible property to True in the BarManager's OnMerge event handler does not show this toolbar
Spark的灵魂:RDD和
DataSet
本课重点讲解Spark 的灵魂RDD 和
DataSet
。讲解RDD 的定义、五大特性剖析及
DataSet
的定义和内部机制剖析;对RDD 弹性特性七个方面进行解析;讲解RDD 依赖关系,包括窄依赖、宽依赖; 解析Spark 中DAG 逻辑视图;对RDD 内部的计算机制及计算过程进行深度解析;讲解Spark RDD 容错原理及其四大核心要点解析对Spark RDD 中Runtime 流程进行解析;通过一个WordCount 实例,解析Spark RDD内部机制; 基于
DataSet
的代码,深入分析
DataSet
一步步转化成为RDD 的过程。
Client
DataSet
运行中出现“Client
DataSet
:
dataset
not in
edit
or
insert
mode
”(一)
1、执行“显示数据后”,再执行Append,
出错
,说明Client
DataSet
处于编辑状态;3、加入 Client
DataSet
1.ReadOnly:=False无效;2、加入 Client
DataSet
1.Active:=True无效;2、执行二次Append或
Insert
,可以不
出错
,但会加入二行数据行。这个代码一执行,彻底让Client
DataSet
处于编辑状态,解决问题。问题是Append,并及时加入一行,录入字符
出错
。1、在执行显示代码最后,加入以下。(1)使用第三方控件。
关于DBGrideh出现
Dataset
not in
edit
or
insert
mode
前两天一直在对DBGrideh 进行操作,我是做一个checkbox 的选择框,对没勾选的记录点击进行添加数据,对有勾选的记录点击进行是否删除数据。我是在选择框的数据改变是事件onupdatedata的事件中对数进行修改,但有时候可以修改,有时候就会出现adoquery1:
dataset
not in
edit
or
insert
mode
的错误,我百思不得其解。 在网上找了好久,有人说是把DBGrideh 关连的adoquery 的locktype的值设为ltBatchOpt
数据库相关
2,498
社区成员
88,445
社区内容
发帖
与我相关
我的任务
数据库相关
Delphi 数据库相关
复制链接
扫一扫
分享
社区描述
Delphi 数据库相关
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章