Field Use in a Project

[SMCmtg]

Hi to All:

I have built my project over the last couple three years and added fields to tables as I needed them. 20 or so odd tables mostly full over many forms & reports. As I was pulling it together. . .many of the fields were not needed so I would delete them from the form or report as I built it, but I never deleted them from the tables. . .

My question is there be a way to build some code or whatever whereby I could see if the field is needed thru out the project or do I have to wade thru it field by field, form by form and report by report?"

Any thoughts or feedback would be deeply appreciated!

THX

Bill

 

[rgbean]

Bill,
Go to the UT (

http://www.universalthread.com/),

click on the Download picture on the right, and choose the Visual FoxPro area. Next enter 'searchstring' (without the
quotes) in the Title area and press Enter. You should get back an entry for:
SearchString.zip May 30, 2000 22:45

Go to the full information page, and download it by clicking on the hyperlink.

As long as you don't have "common" names for your data fields, this utility should help you track down any use of a given field real quick.

Rick

 

[jimstarr]

Hi Bill,

I'm all for tidyness myself, but if it was a lot of work, and if it had the possibility of introducing new errors, I'd forget about removing unneeded fields from my tables.

Jim