备注字段不更新 [英] Memo field not updating

问题描述

我无法更新备忘录字段。请您告诉我访问中的问题。它通过语法错误。





UPDATE [代码] SET测试=_hmHB1 =＃B0 | _hmHI1 =＃B1 | _hmHB2 =＃ B0 | _hmHI2 =＃B0 | _hmVB1 =＃B1 | _hmHB2DY =＃M0WHERE ID = 29



我尝试了什么：



UPDATE [代码] SET测试=_hmHB1 =＃B0 | _hmHI1 =＃B1 | _hmHB2 =＃B0 | _hmHI2 =＃B0 | _hmVB1 =＃B1 | _hmHB2DY = ＃M0WHERE ID = 29

hi ,

iam not able to update memo field .could you please let me know whats the problem in access. its through syntax error.


UPDATE [Code] SET Test = "_hmHB1=#B0|_hmHI1=#B1|_hmHB2=#B0|_hmHI2=#B0|_hmVB1=#B1|_hmHB2DY=#M0" WHERE ID= 29

What I have tried:

UPDATE [Code] SET Test = "_hmHB1=#B0|_hmHI1=#B1|_hmHB2=#B0|_hmHI2=#B0|_hmVB1=#B1|_hmHB2DY=#M0" WHERE ID= 29

推荐答案

首先查看我们无法访问的数据，并检查是否存在ID为29的条目。如果没有行具有该值，则不会更新任何行。

然后查看代码以使用该UPDATE命令，并在执行SQL命令时检查返回值 - 它应该是行已更新。如果不是零，那么Access认为它已经更新了一些行，所以你需要检查你是否有正确的数据库，右表和正确的数据。



我们无法为您执行任何操作：我们无权访问您的代码或数据库。

Start by looking at your data - to which we have no access - and check that an entry exists with an ID of "29". If no rows have that value, no rows will be updated.
Then look at your code to use that UPDATE command, and check the return value when you execute the SQL command - it should be the number of rows updated. If that isn't zero, then Access thinks it has updated some rows, so you need to check that you have the right DB, right table, and right data.

We can't do any of that for you: we don't have access to your code or your DB.

这篇关于备注字段不更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！