1

Topic: Search of not used requests

Somewhere something was.
I can not find.
Who has a code for search of requests in basis which garbage type roll.
Type one-time requests.
------------------------------------------------------------------------
Thanks for the answer.

2

Re: Search of not used requests

58;
Look here http://www.cyberforum.ru/post2479961.html, can and approaches

3

Re: Search of not used requests

58;
And here the topic was, esteem
http://www.sql.ru/forum/976772/vyyavit- … -mysli-est

4

Re: Search of not used requests

Generally - it is unreal. The request can be used from a VBA-code, and you will find it in half of cases of figs.
And than they prevented you? Make hidden, and all affairs...

5

Re: Search of not used requests

wrote:

Generally - it is unreal.

Yes it is fine :-) Here jumped the search unit in all objects  if it is a little of it to twist it is quite possible  for search .
I.e. to walk on a collection query and to fulfill search in each request.  as with system (temporal), but on user queries should .

6

Re: Search of not used requests

bubucha;

Public Const q_prefix As String = "MyQuery _"
'...
Sub
'...
For i = i_from to i_till
'...
Set rs = db. OpenRecordset (q_prefix AND CStr (i-1))
'...
Next
'...

... Also it is not most confused variant.

7

Re: Search of not used requests

guest_rusimport;
At thanks I will look.

8

Re: Search of not used requests

Akina;
They are absolutely not necessary to me, and I and do not remember what are not necessary.
And to stick manually is long and boringly.

9

Re: Search of not used requests

Akina wrote:

bubucha;

Public Const q_prefix As String = "MyQuery _"
'...
Sub
'...
For i = i_from to i_till
'...
Set rs = db. OpenRecordset (q_prefix AND CStr (i-1))
'...
Next
'...

Yes, under forms it is clear.
It is necessary on the code, probably to transverse in search of query name.

10

Re: Search of not used requests

58 wrote:

They are absolutely not necessary to me, and I and do not remember what are not necessary.

If at you not so tree-structured functional, it is possible to rename stupidly all requests, except certainly necessary, and to walk on all functions, catching absence of data source and recovering names. That it is necessary - to export (just in case), and under a knife.

11

Re: Search of not used requests

58;
All requests to delete.
Start to be requested in operation - to recover.

12

Re: Search of not used requests

Akina wrote:

... Also it is not most confused variant.

It agree, the approach does not guarantee 100 % of success... In a set the case is necessary also the competent test :-)

13

Re: Search of not used requests

Akina wrote:

it is passed...
If at you not so tree-structured functional, it is possible to rename all requests stupidly,
Except certainly necessary and to walk on all functions,
Catching absence of data source and recovering names.
That it is necessary - to export (just in case), and under a knife.

Yes, it is more sparing method.
At me it is painfully cardinal.)))

14

Re: Search of not used requests

58 wrote:

Type one-time requests.

I somehow do not have such problems...
To all necessary requests at once I give intelligent names...
The one-time does itself  I (do not interfere) Zapros1, Zapros2...
Not one-time, but then not the necessary I name type tmp_....
Then in a box variant stupidly I delete all ZaprosH and tmp_... Also there are no problems...
Now passed generally on new  - in a database of only 2-3 saved requests
From the point of view that it was absolutely not clear to indirect clever men that whence undertakes...

Dim Q as querydef
SET Q = currentdb.querydefs ("your request saved already")
Q.SQL = "Here the new text of the request"

- on the move in the code you change the saved request and do with it  ...
So it is convenient - you look the code, at once it is visible as as in request becomes (it is not necessary to climb generally in requests)...
In the end of procedure you write there  (about what) and none will be the wiser...
smile))

15

Re: Search of not used requests

I for cleaning and disassemblings with another's code use http://accessdependencychecker.com/
I use in the core global search, and there I look, it is necessary or not on dependences. There is search mode Unused items, Missing sources and Missing targets, but is rare when does without the analysis of all dependences after  on basis. I use old version 1.0.2 since new 2.0 at me did not go, it is necessary to try 2.0.1, it can though earns.
And all the same global search does not guarantee that all places, whence object will be found is caused, . the object name can be stored in basis or generally be formed by the code in runtime.
All to delete and test also approaches only for simple cases since difficult application cannot be run on all branches during reasonable time.
Therefore delete only the explicit I get on, remaining I would not touch.

16

Re: Search of not used requests

MrShin;
Yes.
Thanks.

17

Re: Search of not used requests

vmag;
I from those clever men that did not understand the code which you resulted.
:-)

18

Re: Search of not used requests

58;
Well  here not clear?
- You create in basis plush request (for example on sampling of the minor table), you save with a name for example Zapros1
- Then in the button where the real request is fulfilled, substitute my code and register the text of real request in Zapros1...
- You fulfill not so real request and Zapros1
After that at you already in the unit text, and former real it is possible to delete real request from a DB generally

19

Re: Search of not used requests

2 vmag
You it is serious?

20

Re: Search of not used requests

bubucha;
You it is serious?
Absolutely... If there is such possibility (and even in files mde) why and is not present?
By the way it is taken from same ... Many I think saw this feature, but except a question And ?
Anybody did not have any rational ideas...

21

Re: Search of not used requests

I not about change whining the saved request, I about

wrote:

from the point of view that it was absolutely not clear to indirect clever men that whence undertakes

And

wrote:

In the end of procedure you write there  (about what) and none will be the wiser.

Same humour, yes? :-)

22

Re: Search of not used requests

The same simply changeover of the text of request by other text.
And all.
And where to apply - yes anywhere.

23

Re: Search of not used requests

bubucha;
http://www.sql.ru/forum/1207241/redakti … ??????????
To whom humour, to whom the useful counter...

24

Re: Search of not used requests

Yes a pancake... I do not speak about uselessness as you expressed, "counters")))

25

Re: Search of not used requests

58 wrote:

I from those clever men that did not understand the code which you resulted.
:-)

Just in case an example, I think already and so caught up...