Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to search in an app's symbol tables without opening the app?
I would like to get to know if some apps have an particular value in their data models, like customer number, for example. It is possible to search manually, but maybe there is a better solution, like making a script for automatic search?
I don't think that it's possible but you could store the values of all (needed) fields within an extra table which you again load into a qvw and make your searches there.
- Marcus
Thank you for advise, but I'm not sure it will work in my case: I have about 150 "old" QV apps and I need to check if some of these apps use name or address of a specific customer (with a specific customer number) who wants to be deleted from our databases. He is actually already deleted from db, but some apps need to be reloaded to get new data.
If these old qvw's have separate qvd data-sources you could read them. If not there will be (quite probably) no other way than to look into all qvw's. My suggestion from above means to include an extra load-logic at the end of the normal script and running within a nested loop through all (or a few conditionally ones) symbol-tables and storing the results into qvd's.
I assume it's not what you intended to do. An alternatively might be to create a small macro which runs through all your qvw-folders and fetch the path and filename of the qvw's and putting them into variable. Afterwards the macro triggers a binary-reload to this qvw and within some following script you picked your needed fields from the data and store them into a qvd. After all them you could load these qvd's and check if your customer is there and where it is (of course you load the filename of the qvw, too).
You will need some efforts to develop such logic but afterwards it could run automatically.
- Marcus