备注现场问题？请帮忙。 [英] Memo Field Issue? Please help.

问题描述

大家好，


我的MS Access数据库中有一个名为WorkDescription的字段，它设置为MEMO。


必填：否

允许零长度：是

索引：否

Unicode压缩：是


有时候如果你可以将大量更新粘贴到工作描述更新框，它会给我一个错误


Microsoft JET数据库引擎错误''80040e14''


查询表达式中的语法错误（缺少运算符）&无论更新是什么......


有人可以帮忙吗？谢谢。

Hi All,

There is a field in my MS Access database called WorkDescription and it is set to MEMO.

Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Compression: Yes

Sometimes if you can and paste a large updates to the Work Description update box, it gives me an error

Microsoft JET Database Engine error ''80040e14''

Syntax error (missing operator) in query expression "and whatever the update is ....."

Can someone please help? Thanks.

推荐答案

我认为您收到此错误，因为您的sql字符串包含引号或其他特殊内容chracters。您可以使用替换功能。


例如替换（fieldname，"''"，""）

Hi,

I think you are getting this error as your sql string is containing quotes or other special chracters. You can use Replace function for this.

e.g. Replace(fieldname,"''","")

大家好，


我的MS Access数据库中有一个名为WorkDescription的字段，它设置为MEMO。


必需：否

允许零长度：是

已编入索引：否

Unicode压缩：是


有时，如果可以将大量更新粘贴到工作描述更新框中，则会给出我错了


Microsoft JET数据库引擎错误''80040e14''


查询表达式中的语法错误（缺少运算符）等等更新是.....


有人可以帮忙吗？谢谢。

Hi All,

There is a field in my MS Access database called WorkDescription and it is set to MEMO.

Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Compression: Yes

Sometimes if you can and paste a large updates to the Work Description update box, it gives me an error

Microsoft JET Database Engine error ''80040e14''

Syntax error (missing operator) in query expression "and whatever the update is ....."

Can someone please help? Thanks.

您好shweta123，


感谢您的帮助。我之前从未使用过replace命令。以下是我过去更新的声明。使用REPLACE语句会是什么样子？


strSQL =" UPDATE TableProjects SET"

strSQL = strSQL& " WorkDescription =''"& strWorkDescription&"''，"


Conn.Execute（strSQL）


还有其他字段需要更新。如果更改为REPLACE，是否会影响其他字段？再次感谢您的帮助。

Hi shweta123,

Thanks for your help. I have never used the replace command before. Below is the statement that I used to update. What would it look like with the REPLACE statement?

strSQL = "UPDATE TableProjects SET "
strSQL = strSQL & " WorkDescription = ''"& strWorkDescription &"'', "

Conn.Execute(strSQL)

There are other fields that need to update as well. If you change to REPLACE, is it going to affect the other fields? Thanks for your help again.

像这样：


strSQL =" UPDATE TableProjects SET"

strSQL = strSQL& " WorkDescription =''"&替换（strWorkDescription，"''，""）&"''，"

Like this:

strSQL = "UPDATE TableProjects SET "
strSQL = strSQL & " WorkDescription = ''"& Replace(strWorkDescription,"''","") &"'', "

这篇关于备注现场问题？请帮忙。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！