Find all resources using a database connection.

[Steve James]

Hi, in pre 5.0 Ebase I would simply find all the references from a database connection.

How do I find all resources using 'x' database connection?

Thanks

[Segi]

Are you asking how you can find out which database resources are using a given database connection ?

[Steve James]

Hi Segi, yes.

[Jon]

Click the Search Files icon on the main toolbar, select Database Resources and maybe Dynamic Lists and enter the connection name.

[Steve James]

Hi, I should have mentioned that I had tried that without success.

Thanks

[Jon]

Yes sorry you're right, I just found a bug saying exactly the same thing. Quickest way is probably to do a Windows file content search against the workspace directory.

[Steve James]

Thanks Jon,

For anyone needing to do this you'll need to add .eb files to the indexing options to index properties and file content.

https://www.howtogeek.com/99406/how-to- ... ws-search/

We don't have some of our workspaces on our local PC but I can write a quick Ebase form to loop through all files and look for the specified content.

Thanks

[Segi]

Steve,

If you are currently using Ebase 5.0 or higher there's also another way that I find much easier.

I use a text editor called Notepad++ https://notepad-plus-plus.org/ which is a very powerful text editor.

One of its features is "find in files" which lets you search the contents of all files in a directory that you choose for a given string.

So you could point it to your Ebase workspace folder and search for

database="YOUR DB CONNECTION NAME" and it will return all database resources that use that database connection.

[Steve James]

Ahh brilliant thanks Segi.

I prefer EditPadPro but I'd not considered "find on disk" which also exists.
Excellent, I have some colleagues who use Notepad++

That'll be really handy for other reasons as well I'm sure....

Thanks again

[Segi]

You're welcome. I can't recommend Notepad++ enough.

[Steve James]

Yes it's used a lot in our department.

The one thing that has prevented me jumping from EditPadPro is copying search matches.

That is I set up a regular expression and search, EditPadPro has the option to copy the matched results into list. I use this a lot to generate things like a sql statement for each match.