用于查询的字段映射工具 [英] Field Mapping tool for queries
问题描述
我的老板要我生成所有
查询的列映射报告。基本上，我们从ORACLE获取数据。从ORACLE表中创建新表有一个问题。
。然后，有报告和使用新表的
查询。
是否有可以生成
查询。
示例：
========
查询1：
Field1 - >来自access.field1
Field2 - >来自access.field2
使表查询从oracle表到新表：
access.field1 - >来自oracle_tbl.field1
access.field2 - >来自oracle_tbl.field2
更好，如果它可以直接映射到oracle源：
Field1 - >来自oracle_tbl.field1
Field2 - >来自oracle_tbl.field2
提前致谢！
Ross
Hi,
My boss is asking me to generate a column mapping report of all the
queries. Basically, we get our data from ORACLE. There''s a queary that
create new table from ORACLE tables. Then, there are reports and
queries that uses the new table.
Is there an add in or tool that can generate mapping reports of the
queries.
Example:
========
Query 1:
Field1 --> from access.field1
Field2 --> from access.field2
make table query from oracle table to new table:
access.field1 --> from oracle_tbl.field1
access.field2 --> from oracle_tbl.field2
Better if it can map it straight to oracle source:
Field1 --> from oracle_tbl.field1
Field2 --> from oracle_tbl.field2
Thanks in advance!
Ross
推荐答案
2004年12月7日10:24:11 -0800， te**@i-vibe.com 写道：
On 7 Dec 2004 10:24:11 -0800, te**@i-vibe.com wrote:
我的老板要我生成所有
查询的列映射报告。基本上，我们从ORACLE获取数据。有一个从ORACLE表创建新表的任务。然后，有报告和
查询使用新表。
是否有添加或工具可以生成
查询的映射报告。
示例：
========
查询1：
Field1 - >来自access.field1
Field2 - >来自access.field2
使表查询从oracle表到新表：
access.field1 - >来自oracle_tbl.field1
access.field2 - >来自oracle_tbl.field2
如果它可以直接映射到oracle源代码更好：
Field1 - >来自oracle_tbl.field1
Field2 - >来自oracle_tbl.field2
提前致谢！
Ross
Hi,
My boss is asking me to generate a column mapping report of all the
queries. Basically, we get our data from ORACLE. There''s a queary that
create new table from ORACLE tables. Then, there are reports and
queries that uses the new table.
Is there an add in or tool that can generate mapping reports of the
queries.
Example:
========
Query 1:
Field1 --> from access.field1
Field2 --> from access.field2
make table query from oracle table to new table:
access.field1 --> from oracle_tbl.field1
access.field2 --> from oracle_tbl.field2
Better if it can map it straight to oracle source:
Field1 --> from oracle_tbl.field1
Field2 --> from oracle_tbl.field2
Thanks in advance!
Ross
您好
对不起，不知道你是不是正在寻找一个模式类型的地图
或者你是否需要跟踪查询的基础源对象
哪些有AS子句。
DAO属性sourcefield，sourcetable做后者如果查询
字段不是表达式（但如果它们可以给出有趣的答案）。
别想这个功能在ADO中。
如果你的老板喜欢报道，他可能会对FMS Total Access感兴趣
分析器，其中包含300多份报告。请参阅 www.fmsinc.com
David
Hi
Sorry don''t understand whether you are looking for a schema-type map
or whether you need to track the underlying source objects for queries
which have AS clauses.
The DAO properties sourcefield, sourcetable do the latter if query
fields are not expressions (but can give funny answers if they are).
Don''t think this functionality is is in ADO.
If you boss likes reports he may be interested in FMS Total Access
analyser which "contains over 300 reports" see www.fmsinc.com
David
感谢您的回复，
我想我的陈述很复杂。
我只是想看看所有的quey结构并把它放在excel上看看
使用了哪些表格和字段。
我看到了使用MsysQueries和MSysObjects，但它没有显示未标记为在查询中显示的
字段。
事情是，我我还在等待管理员访问我的电台，然后我才能安装FMS演示版。 FMS TA可以做我需要的吗？
暂时，有没有人知道如何用宏或
VBscript或共享软件做我需要的东西？
谢谢。
Ross
Thanks for the reply,
I guess I made my statement complicated.
I just want to see all the quey structure and put it on excel to see
which tables and fields are used.
I saw the use of MsysQueries and MSysObjects, but it does not show the
fields that are not marked to show in the query.
The thing is, i''m still waiting for admin access to my station before I
can install the FMS demo. Can FMS TA do what I need?
Temporarily, does anyone knows how to do what I need with a macro or
VBscript or a shareware?
Thanks.
Ross
感谢您的回复，
我想我的陈述很复杂。
我只是想看看所有的quey结构并把它放在excel上看看
哪些表和字段被使用。
我看到使用MsysQueries和MSysObjects，但它没有显示未标记在查询中显示的
字段。
事情是，我还在等待管理员访问我的电台，然后我才能安装FMS演示。 FMS TA可以做我需要的吗？
暂时，有没有人知道如何用宏或
VBscript或共享软件做我需要的东西？
谢谢。
罗斯
Thanks for the reply,
I guess I made my statement complicated.
I just want to see all the quey structure and put it on excel to see
which tables and fields are used.
I saw the use of MsysQueries and MSysObjects, but it does not show the
fields that are not marked to show in the query.
The thing is, i''m still waiting for admin access to my station before I
can install the FMS demo. Can FMS TA do what I need?
Temporarily, does anyone knows how to do what I need with a macro or
VBscript or a shareware?
Thanks.
Ross
这篇关于用于查询的字段映射工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
