Filemaker Sql 对名称中带有空格的列进行查询
我有一个 ODBC DSN 设置,可以从 ASP.Net 应用程序访问 Filemaker 数据库。我正在尝试形成一个有效的查询,其中列名包含空格。在 T-SQL 中,您可以将其括在 [] 中。但在这种情况下我无法让它发挥作用。这是一个有效的查询:
select * from ua_inventory where location like '%a%'
但这不是:
select * from ua_inventory where [item place] like '%a%'
我收到以下错误: [DataDirect][ODBC SequeLink 驱动程序][ODBC Socket][DataDirect][ODBC FileMaker 驱动程序][FileMaker]SQL 中的解析错误
有谁知道如何在表和/或列名称中包含空格的情况下形成查询?
提前致谢
I have an ODBC DSN setup to hit a Filemaker database from my ASP.Net application. I'm trying to form a valid query where the column name has spaces in it. In T-SQL, you would enclose it in []. But I fail to get it to work in this case. Here's a valid query:
select * from ua_inventory where location like '%a%'
But this is not:
select * from ua_inventory where [item place] like '%a%'
I get the following error:
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
Does anyone have a clue how to form queries where the table and/or columns have spaces in the name?
Thanks in advance
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
以下是一些示例查询:
要记住的重要一点是对象(表名和列名)需要双引号
本文底部的前后注释确实很有帮助:
http://www.nathanm.com/filemaker-pro-odbc-quirks/
Here are some example queries:
The important thing to remember is objects (table name & column names) need double quotes
The back-n-forth comments at the bottom of this artcle really helped out:
http://www.nathanm.com/filemaker-pro-odbc-quirks/