是否可以获得附件字段下的表格？ [英] Is It Possible to Get at the Table Underlying an Attachment Field?

问题描述

我需要能够列出存储在表格中的所有附件。 我可以找到隐藏表作为附件字段的基础，但无法找到查询它的原因。

I need to be able to list all of the attachments stored in a table.  I can find the hidden table that underlies the attachment field but cannot find a why to query it.

例如，如果隐藏表名为f_7C675382C9BE4393BE17C14BA232718D_AttachementField我希望能够执行：SELECT [FileName] FROM [f_7C675382C9BE4393BE17C14BA232718D_AttachementField]

For example, if the hidden table is named f_7C675382C9BE4393BE17C14BA232718D_AttachementField I would like to be able to execute: SELECT [FileName] FROM [f_7C675382C9BE4393BE17C14BA232718D_AttachementField]

MSysObjects表示类型为1，这是一个本地表。 但是，它设置了一些额外的标志，很难直接引用它。

MSysObjects says the type is 1 which is a local table.  However, it has a few extra flags set that make it difficult to directly reference it.

任何建议都将受到赞赏。

Any suggestions would be appreciated.

http://www.saberman.com

推荐答案

我不确定你为什么要问这个，因为我所做的每一个测试只用表中的普通查询并从查询中选择Attachment.Name来显示它。  您是手工编写所有查询而根本不使用QBE网格吗？  我是
猜测答案是肯定的，因为它在QBE网格中非常明显。 （不要试图让你失望，只想弄清楚你是如何错过它的。）

I'm not sure why you are asking this because every test I've done shows it with just a normal query from the table and selecting the Attachment.Name from the query.  Do you write all your queries by hand and not use the QBE grid at all?  I'm guessing the answer is yes because it is quite visible right there in the QBE grid. (not trying to put you down, just trying to figure out how you missed it.)

这篇关于是否可以获得附件字段下的表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！