>I'm thinking of using a search tool such as DT search or Google desktop to index my general work files, but I'm thinking these tools won't do anything for my code stored in scx / vcx files. My thought is to develop some tool that runs nightly to pull all the code out of the tables into into a text file in the same directory. It would also be cool to dump table structures into text files too. Any comments on this approach or know of any similar tools that already exist? Maybe the code references tool could be modified to support searching code in multiple directories, but frankly I've never liked this tool. Too slow and often gives incomplete search results. I'm looking for Google-query speed here.

As Beth mentioned GoFish does most of this very well. You can specify a project or a directory to search, and optionally include subdirectories. There's also a checkbox to ignore comment lines. Yup, it does look into every m.PRG and .??X file for the string you want, as well as .SPR, .MPR, .HTM, .ASP, .INI, and .H. Dump your table structures into .PRG or .HTM files (never mind that they're not really .PRGs, the search will work just fine), and you get almost everything you asked for.

Something else that might be useful is HackCX Professional by Rick Schummer. Look at http://www.whitelightcomputing.com/prodhackcxpro.htm for info about this. There were less-capable freeware versions available at one time, but I don't see any reference now.

>Thanks,

From one 'shoe' to another, you're welcome.