语法错误缺少运算符但在哪里？ [英] Syntax Error Missing Operator but Where?

问题描述

嘿伙计们，我正在使用一个与命令按钮绑定的嵌入式sql语句来将记录追加到某个表中。 sql语句的代码如下：

Hey guys, I''m using an embedded sql statement tied to a command button to append records in a certain table. The code for the sql statement is as follows.

展开 | 选择 | Wrap | 行号

推荐答案

您需要空格。此外，您可能需要更改[表格]！[主表格]！[子表格]！[控制名称]至[表格]！[主表格]！[子表格]！[表格]！[控制名称]但我我对此并不完全确定。

You need spaces. Also, you may need to change [Forms]![Main Form]![Sub Form]![Control Name] to [Forms]![Main Form]![Sub Form]![Form]![Control Name] but I''m not entirely sure about this.

展开 | 选择 | Wrap | 行号

感谢兔子，以及在所有的上添加AND' ''WHERE''语句修复了错误。现在虽然，它没有给出错误，但它也没有''看到''附加到表LPID的任何数据。这个sql语句的全部目的是因为我有一个更新表的子表单。虽然该子表单的控件设置为该表的正确控件，但该子表单并未更新表格。我也担心用户输入数据而不是真的想要它。这样，sql语句只会在单击提交按钮后运行。这应该会严重减少坏数据的数量。


非常感谢你能给我这个问题的任何其他帮助。

Thanks rabbit, that along with adding AND''s on all of the ''WHERE'' statements fixed the error. Now though, It doesn''t give an error, but it also does not ''see'' any data to append to the table LPID. The whole purpose of this sql statement was because I have a subform that is to update a table. That subform though was not updating the table even though it''s control was set to the proper control for that table. I also was worried about users entering data and not really wanting it. This way, the sql statement will only run after the submit button is clicked. This should cut down on the amount of bad data tremondously.

Any other help you can give me on this problem would be greatly appreciated.

我会尝试让这个追加查询在常规查询中工作，然后从SQL视图中复制它的SQL。

I would try to get this append query working in a regular query and then just copy it''s SQL from the SQL view.

这篇关于语法错误缺少运算符但在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！