Documenting Database Calls in an App

[rockyr]

Does anyone know of a program that will scan an application and document database calls? I've got a vb4 (16 bit) app that makes calls to a lot of SQL tables. I'd like to have something that will scan the code and document those calls as I believe there are extra tables in the database that I can get rid of.

Thanks in advance

 

[MichaelRed]

I don't think you need a 'program'. In most aps the databases(s) are instantiated in one (or a very few) places. Visit these and collect the db name(s). Do a global search on what ever you find.

Finding the tables/queries should be easy enough. Unless there is something non-standard, all of the tables will be idintified by "Set rstX = dbs.Open...." type of construct.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over