FROM子句中的语法错误 [英] Syntax Error in FROM clause

问题描述

任何人都可以告诉我如何编写以下代码以避免FROM原因中的语法错误。我知道这是因为我的撇号，但我不能改变这个文件名。我以前曾经解决过这个问题，但是找不到我是怎么做的。


提前致谢

Can anyone tell me how to code the follow to avoid the Syntax Error in FROM cause. I know it is because of my apostophe but I can not change this file name. I got around it once before but can''t find how I did it.

Thanks in advance

展开 | 选择 | Wrap | 行号

推荐答案

在提出查询帮助时，提及您正在使用的数据库是个好主意。你可以告诉我一些问题。


1）当你正在寻找的文本中有一个撇号时，撇号应加倍...所以如果你他们想要在列有Montey's Street的专栏中找到文字。在它里面你会把它改成蒙特街。



2）我不知道你可以指定一张这样的桌子在查询中（我从来没有，但从未使用过Access），但我可能是错的。通常，您将打开数据库并运行查询，或在连接字符串中指定数据库并通过代码运行查询。如果你正在研究一个实际有用的例子，那么将单个撇号加倍会修复它。

It''s a good idea to mention what database you''re using when asking for query help. You have a few problems from what I can tell.

1) Apostrophes should be doubled when there is a single apostrophe in the text you''re looking for... So if you were wanting to find text in a column that has "Montey''s Street" in it you would change it to "Montey''''s Street".


2) I don''t know that you can specify a table like that in the query (I never had but never used Access much) but I could be wrong. Typically you would open a database and run the query, or specify the database in a connection string and run the query through code. If you are working off an example that actually works, doubling the single apostrophes would fix it.

展开 | 选择 | Wrap | 行号

打开上述数据库，然后执行查询：

Hi,

Open the said database, and Execute the query:

展开 | 选择 | Wrap | 行号

展开 | 选择 | Wrap < span class =codeDivider> | 行号

这篇关于FROM子句中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！