“操作必须使用可更新的查询”？ [英] "Operation Must Use An Updatable Query"?

问题描述

我在将记录添加到本地.DB文件（使用

Paradox连接字符串）时遇到了一些麻烦。我检查了文件权限，并且对于

测试目的，将Everyone设置为Full访问权限。但似乎我可以将
添加一个且只有一条记录到表中，任何其他尝试插入

a记录都会产生错误：


操作必须使用可更新的查询


我可以通过其他方式访问该表，删除该记录，再次尝试
，相同的结果。然后我关闭我的应用程序，在表中保留记录

，重新打开应用程序并再试一次，它在输入任何内容之前给出了

相同的错误（从那以后表中已有一条且只有一条记录

。


任何想法可能出错？

I''m having a bit of trouble adding records to a local .DB file (using a
Paradox connection string). I checked the file permissions, and for
testing purposes set Everyone to Full access. But it seems that I can
add one and only one record to the table, any other attempts to insert
a record generate the error:

"Operation Must Use An Updatable Query"

I can access the table via other means, delete that one record, try
again, same results. Then I close out my application, leave the record
in the table, re-open the application and try again, and it gives the
same error before entering anything (since one and only one record is
already in the table).

Any idea what might be wrong?

推荐答案

听起来像是一个Paradox或数据库问题。与C＃无关？

" cyber0ne" < CY ******* @ gmail.com>在消息中写道

新闻：11 ********************** @ i39g2000cwa.googlegr oups.com ...

Sounds like a Paradox or database issue. Nothing to do with C#?
"cyber0ne" <cy*******@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...

我在将记录添加到本地.DB文件（使用
Paradox连接字符串）时遇到了一些麻烦。我检查了文件权限，并且为了测试目的，将Everyone设置为Full访问权限。但似乎我可以在表中添加一条且只有一条记录，任何其他尝试插入记录都会产生错误：

操作必须使用可更新的查询

我可以通过其他方式访问该表，删除该记录，再次尝试
，结果相同。然后我关闭我的应用程序，将记录保留在表格中，重新打开应用程序并再试一次，在输入任何内容之前它会给出相同的错误（因为只有一条记录是
知道可能出错的是什么？

I''m having a bit of trouble adding records to a local .DB file (using a
Paradox connection string). I checked the file permissions, and for
testing purposes set Everyone to Full access. But it seems that I can
add one and only one record to the table, any other attempts to insert
a record generate the error:

"Operation Must Use An Updatable Query"

I can access the table via other means, delete that one record, try
again, same results. Then I close out my application, leave the record
in the table, re-open the application and try again, and it gives the
same error before entering anything (since one and only one record is
already in the table).

Any idea what might be wrong?

>听起来像是一个Paradox或数据库问题。与C＃无关？


可能，但我在这条路线上不知所措，因为其他开发

环境可以很好地访问它。我想知道它是否仅仅是我自己忽略的.NET本身的东西。


我的Delphi 7应用程序没有问题，但.NET中的任何内容（用

Visual Studio或Delphi 2005编写）都可以。

> Sounds like a Paradox or database issue. Nothing to do with C#?

Possible, but I''m at a loss on that route since other development
environments can access it just fine. I''m wondering if it''s just
something in .NET itself that I''m overlooking.

My Delphi 7 apps have no problem, but anything in .NET (written in
Visual Studio or Delphi 2005) does.

你能展示一些代码吗？你是用来尝试更新

数据库的？


-

- Nicholas Paldino [.NET / C＃MVP ]

- mv*@spam.guard.caspershouse.com

" cyber0ne" < CY ******* @ gmail.com>在消息中写道

新闻：11 ********************** @ i39g2000cwa.googlegr oups.com ...

Can you show some code which you are using to try and update the
database with?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"cyber0ne" <cy*******@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...

我在将记录添加到本地.DB文件（使用
Paradox连接字符串）时遇到了一些麻烦。我检查了文件权限，并且为了测试目的，将Everyone设置为Full访问权限。但似乎我可以在表中添加一条且只有一条记录，任何其他尝试插入记录都会产生错误：

操作必须使用可更新的查询

我可以通过其他方式访问该表，删除该记录，再次尝试
，结果相同。然后我关闭我的应用程序，将记录保留在表格中，重新打开应用程序并再试一次，在输入任何内容之前它会给出相同的错误（因为只有一条记录是
知道可能出错的是什么？

I''m having a bit of trouble adding records to a local .DB file (using a
Paradox connection string). I checked the file permissions, and for
testing purposes set Everyone to Full access. But it seems that I can
add one and only one record to the table, any other attempts to insert
a record generate the error:

"Operation Must Use An Updatable Query"

I can access the table via other means, delete that one record, try
again, same results. Then I close out my application, leave the record
in the table, re-open the application and try again, and it gives the
same error before entering anything (since one and only one record is
already in the table).

Any idea what might be wrong?

这篇关于“操作必须使用可更新的查询”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！