为什么此 SQL 更新失败并显示“解析查询时出错"? [英] Why is this SQL update failing with "there was an error parsing the query"?

问题描述

此查询的早期问题已解决here 但现在这个查询:

An earlier problem with this query was resolved here but now this query:

...失败:

为什么?它工作了一次(这是对上面链接的较早问题的修复).

Why? It worked once (it was the fix for the earlier question linked to above).

err msg的描述"行中看不见的部分是:[Token line number,Token line offset,,Token in error,,]"

The unseen part of the err msg's "Description" line is: "[Token line number,Token line offset,,Token in error,,]"

推荐答案

奇怪的是，删除表名和列名周围的括号允许更新成功触发.

Strangely enough, removing the brackets surrounding the table name and column name allowed the update to fire successfully.

那么为什么它以前有用过一次，我不明白.

So why it worked once before, I don't grok.

这篇关于为什么此 SQL 更新失败并显示“解析查询时出错"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！