隐形查询头 - Scratcher [英] Invisible Query Head-Scratcher

问题描述

作为我通过清除

旧的未使用的东西整理旧数据库的努力的一部分，我通过循环

这样的querydef：


For each qry in db.QueryDefs

''get qry.Name

''得到qry.SQL

循环


这给了我通常的~sq_ *和用户定义查询列表。很好。

远。


然后我继续尝试删除我认为未使用的查询

的查询他们不在那里！尽管事实上我从

QueryDefs获得了这些查询的名称和完整SQL，但它们并没有出现在数据库窗口中。它们也不是
在MSysObjects表中进行任何外观。他们只是简单地说b $ b不存在!!


这些查询鬼魂如何消失？在数据库中，怎么做？b $ b我打败了他们？


我不想把对象导入新数据库，我更多好奇的是

到底了！第一个说编译或者反击
反编译的人会得到一个e-slap（也没有摆脱它们）！

As part of my ongoing efforts to tidy up an old database by weeding out
old unused stuff, I exported all the query data by looping through
querydefs like so:

For Each qry In db.QueryDefs
''get qry.Name
''get qry.SQL
loop

This gave me the usual list of ~sq_* and user defined queries. Fine so
far.

I then proceeded to attempt to delete queries that I identified as
being unused, only to find that they were not there! Despite the fact
that I obtained the name and full SQL for these queries from the
QueryDefs they do not appear in the database window. Neither do they
make any appearance whatsoever in the MSysObjects table. They simply
dont exist!!

How are these "ghosts of queries long gone" in the database, and how do
I vanquish them?

I don''t want to import objects into a new database, I''m more curious to
get to the bottom of this! And the first person to say compile or
decompile will get an e-slap (neither gets rid of them)!

推荐答案

2005年9月8日06:02:10 -0700，BillCo <共********** @ gmail.com>写道：


为什么你认为它们是隐形的，难以处理？

对。

所以请不要管它们。


-Tom。

On 8 Sep 2005 06:02:10 -0700, "BillCo" <co**********@gmail.com> wrote:

Why do you think they are invisible and hard to handle?
Right.
So leave them alone.

-Tom.

作为我通过清除来整理旧数据库的持续努力的一部分旧的未使用的东西，我通过循环遍历
querydef导出所有查询数据，如下所示：

每个qry在db.QueryDefs
''获取qry.Name
''得到qry.SQL
循环
这给了我通常的~sq_ *和用户定义查询列表。很好。

然后我继续尝试删除我认为未被使用的查询，却发现他们不在那里！尽管我从
QueryDefs获取了这些查询的名称和完整SQL，但它们并没有出现在数据库窗口中。它们也不会在MSysObjects表中显示任何外观。它们根本就不存在!!

这些查询鬼魂如何消失？在数据库中，我如何击败他们？

我不想将对象导入新的数据库，我更好奇的是这个底部！第一个说编译或反编译的人会得到一个e-slap（既没有摆脱它们）！

As part of my ongoing efforts to tidy up an old database by weeding out
old unused stuff, I exported all the query data by looping through
querydefs like so:

For Each qry In db.QueryDefs
''get qry.Name
''get qry.SQL
loop

This gave me the usual list of ~sq_* and user defined queries. Fine so
far.

I then proceeded to attempt to delete queries that I identified as
being unused, only to find that they were not there! Despite the fact
that I obtained the name and full SQL for these queries from the
QueryDefs they do not appear in the database window. Neither do they
make any appearance whatsoever in the MSysObjects table. They simply
dont exist!!

How are these "ghosts of queries long gone" in the database, and how do
I vanquish them?

I don''t want to import objects into a new database, I''m more curious to
get to the bottom of this! And the first person to say compile or
decompile will get an e-slap (neither gets rid of them)!

谢谢汤姆，非常有帮助！

Thanks Tom, very helpful!

它们是隐形的，因为它们不会出现在数据库窗口中或

in MSysObjects窗口。我从来没有说过他们难以处理。


我不想让他们独自离开的原因是

1.他们是在那里，但还没有......你甚至不会有点好意思吗？

2.我已宣布对臃肿的战争

3.我想了解所有关于访问权限的信息，这意味着找出这些小爆炸者逃离删除网络的地方以及如何完成删除它们的工作。

删除它们。


任何人都有任何想法吗？

They are invisible because they don''t show up in the database window or
in the MSysObjects window. I never said they were "hard to handle".

The reason I don''t want to leave them alone is that
1. They are there, and yet not there... wouldnt you be even a little
curious?
2. I''ve declaired war on bloat
3. I want to learn all about access, which means finding out where
these little blighters escaped the deletion net and how to finish the
job of removing them.

Anyone have any ideas?

这篇关于隐形查询头 - Scratcher的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！