Dynamic SQL generation for the UpdateCommand is not Supported against a SelectCommand that does not

最新推荐文章于 2021-06-29 01:06:44 发布
最新推荐文章于 2021-06-29 01:06:44 发布
阅读量1.5k 收藏 1
点赞数 1
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yingwang9/article/details/80831719
版权

错误提示：

Dynamic SQL generation for the UpdateCommand is not Supported against a SelectCommand that does not return any key column information.

可能原因

当前被保存的表无主键


yingwang9
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
EhLib 9.1.038 for D7-XE-10.2
03-21
The EhLib set contains components and classes for various versions of the Delphi programming language and to increase the capacity of the user’s database database software to interact with users. List and features of the components included in the EhLib collection: TDBGridhEh: Take advantage of all the features of TDBGrid and several newer features for: Allows you to select records, columns, and quadrilateral environments. Certain titles attributed to multiple or all columns. Putting a footnote that can represent the values ​​of the total fields, the number, and the rest. Ability to resize columns to adjust the width of the table with the width of the user table. Possibility to change height and title And… TPrintDBGridEh: Provides features and procedures for previewing and printing from the TDBGridEh component with more features such as: Ability to enlarge rows vertically, so all text can be printed. Possibility to enlarge the table to cover the whole page. Possibility to preview and print titles for tables Possibility to preview and print headers and footers to use current page display macros, current date, … And… TDBVertGridEh: Component to display a record of data (dataset) vertically. Has a special column for displaying field titles. Ability to edit and modify cell content, such as those in DBGridEh. TDBLookupComboboxEh: All features of the TDBLookupCombobox are also available, including: Possibility to display with flat template Ability to assign a value like KeyValue only to display the text attribute. Ability to write (assign) values ​​to the text property (text property) as previously not included in the data list (Style = csDropDownEh). Ability to maintain KeyValue value and text so that they do not affect the values. TDBEditEh: To display the editing area, a linear or multi-line to change the field of data or use as a purely demo. TDBDateTimeEditEh: To display the editing of the date or time on a line so that it can edit the date and time field in the data, or use it in a purely demo-like environment without changing the data. TDBComboBoxEh: To display the editing box, one or more lines are available to scroll through the list for editing data fields or use only to display without changing the data. TDBNumberEditEh: To display the numeric editing environment for editing a field containing numeric content from the data or use it solely for displaying and without changing data. TDBSumList: To count the total and amount of records in TDataSet with simultaneous editing. This component lists a list of TDBSum objects that include the type of operation (goSum or goCount), as well as the field name for displaying the calculation, and performs the corresponding request. TPreviewBox: Possibility to create a personal preview at runtime. TPrinterPreview: Provide a memory space for stunning data to print as they want to print. This component has all the functions and features of the TPrinter object. TPropStorageEh: Component with the ability to save or read the properties of the ini files, registry and … TMemTableEh: To store data in memory. It is also possible to consider the form of an array of records. Besides that: It supports a specific environment that allows the use of the DBGridEh component that can display all data without having to remove the active record. It is possible to fetch data from the TDataDriverEh object. And… TDataDriverEh: Responsible for performing two tasks: 1. Send data to TMemTableEh. 2. Processing TMemTableEh modified records (saving in another data or using an event to process changes) And… TDataSetDriverEh: Includes DataDriver, which is responsible for transferring TMemTableEh records from other databases. Process the records that have been modified in TMemTableEh and write them in another data set. TSQLDataDriverEh: A global interface for data and their interaction with the server using SQL. This component consists of five TSQLCommandEh objects: SelectCommand, DeleteCommand, InsertCommand, UpdateCommand, GetrecCommand. Each of these objects holds SQL commands and parameters to run a variety of SQL commands. TBDEDataDriverEh: To use the DataDriver Component. This component is responsible for assigning the connection, so that DataDriver sends queries to the server. TIBXDataDriverEh: The DataDriver component that interacts with the database server using the IBX driver. This component is responsible for assigning the connection, so that DataDriver sends queries to the server. TDBXDataDriverEh: The DataDriver component that interacts with the database server using the DBX driver. This component is responsible for assigning the connection, so that DataDriver sends queries to the server. TADODataDriverEh: The DataDriver component that interacts with the database server using the ADO driver. This component is responsible for assigning the connection, so that DataDriver sends queries to the server.
在使用DataAdapter时报错："Dynamic SQL generation for the DeleteCommand is not supported against a......
Wannna的博客
02-23 820
在使用DataAdapter时报错：“Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.”(不返回任何键列信息的SelectCommand不支持UpdateCommand的动态SQL...
tableviewer setdata to html id,绑定DataTable的Datagridview如何更新
weixin_31610297的博客
06-29 89
引用4楼Z65443344的回复:自己试一下呗既然单表查询好使了,多表查询有什么区别吗如果不好使再纠结为什么今天试了发现异常DynamicSQLgenerationisnotsupportedagainstmultiplebasetables.using(OleDbConnectionconn=newOleDbConnection(con)){try{if(c...
2006年我的博客文章整理列表
坚强2002@CSDN
12-07 872
.netXPath语法posted @ 2006-12-06 13:19 坚强2002 阅读(1) | 评论 (0)  编辑 Visual Studio 2005 类设计器posted @ 2006-11-17 11:22 坚强2002 阅读(8) | 评论 (0)  编辑 C#的17种"Hello World"！posted @ 2006-11-17 0
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not ...
weixin_30785593的博客
04-17 609
数据保存出此错误信息:Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.经查是因为做了一个备份表,而影响了数据表tablename的结构,导致pk不见,而备份tablename1的p...
关于绑定自动生成的下拉式菜单的错误
anluo4560的博客
09-25 236
最近在做一个自动生成控件并更新内容的东东，但是出现了意想不到的错误。在初始化页面的时候，我绑定了生成的控件（下拉菜单），并选择其中一个做为选中值，在更新中（button_click事件中），我又绑定了该控件，并选择相同的一个结果。这时会出现错误：DROPDOWNLIST不能有多个值被选中。。。 绑定控件事件： dim...
EhLib 8.0 Build 8.0.023 Pro Edition FullSource for D7-XE8
01-04
(for application) event which it is necessary to write to execute SQL expressions on the server. TBDEDataDriverEh, TIBXDataDriverEh, TDBXDataDriverEh and TADODataDriverEh Components. These are ...
在ASP.NET 2.0中操作数据之三十九：在DataList的编辑界面里添加验证控件
01-02
在前面一章里我们学习了如何在DataList的UpdateCommand事件处理中添加异常处理代码，以便在出现异常时捕捉它并显示友好的错误信息。然而理想的编辑界面应该包含验证控件，用来在第一时间里阻止用户输入一些非法数据...
在ASP.NET 2.0中操作数据之四十：自定义DataList编辑界面
01-02
导言 　DataList的编辑界面由EditItemTemplate里的标记语言和web控件定义。在目前为止所做的DataList编辑功能的例子里，编辑界面都只包含TextBox。在前面一章里，我们通过添加验证控件来增加了用户...在UpdateCommand
EhLib 9.1.024
10-10
(for application) event which it is necessary to write to execute SQL expressions on the server. TBDEDataDriverEh, TIBXDataDriverEh, TDBXDataDriverEh and TADODataDriverEh Components. These are ...
Dynamic SQL
wocalenimade的博客
12-17 240
Dynamic SQL One of the most powerful features of MyBatis has always been its Dynamic SQL capabilities.  If you have any experience with JDBC or any similar framework, you understand how painful
ADO.NET出错原因:Dynamic SQL generation for the UpdateCommand is not Supported ……
weixin_30376163的博客
06-07 122
由于用的是dataset删除。可能没有主健或备份表出现主健冲突 转载于:https://www.cnblogs.com/shengel/archive/2007/06/07/775830.html
OleDbDataAdapter.update更新数据成功，但数据没有变化
wswxfwps的专栏
03-13 4873
问题如题，更新时，输出窗口输入如下信息： Dynamic SQL generation for the UpdateCommand is not Supported …… 发现就是因为在从数据库中获取数据的时候，没有将表中的主键列一起取出，因此在更新的时候，因为没有主键，所以造成的更新失败。 因此，切记： 取数据时，主键必须一起取出。
SQL语句执行错误:对于不返回任何键列信息的 SelectCommand，不支持 UpdateCommand 的动态 SQL 生成。
最新发布
06-11
这个错误通常是由于在使用 DataAdapter 更新数据时，DataAdapter 没有正确识别主键或没有正确设置适配器的 UpdateCommand 属性所导致的。这可能是由于以下原因之一： 1. 数据库表中没有主键，或者主键被更改了。DataAdapter 需要知道主键以便能够正确地生成 UpdateCommand。 2. 在生成 DataAdapter 时，没有设置适配器的 SelectCommand 属性。DataAdapter 需要知道如何选择要更新的数据行。 为了解决这个问题，你可以尝试以下步骤： 1. 确认数据库表中有主键，并且主键没有被更改。如果需要，可以使用 SQL 语句 ALTER TABLE 添加主键。 2. 确认 DataAdapter 的 SelectCommand 属性被正确设置。SelectCommand 应该返回所有要更新的数据行，并且应该返回主键列。 3. 确认 DataAdapter 的 UpdateCommand 属性被正确设置。UpdateCommand 应该包括所有要更新的列，并且应该使用主键列作为 WHERE 子句。 如果你仍然遇到问题，请检查你的 SQL 语句和 DataAdapter 配置，并确保它们正确匹配。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值