Find out list of tables, views and stored procedure used in vb form

  • Thread starter Thread starter T.S.Negi
  • Start date Start date
T

T.S.Negi

Hello All,

I want to Find out list of tables, views and stored procedure used in vb form.
If any body have any idea about it, pls.let me know.


Thanx in adv.

T.S.Negi
 
Dim c as Control

For Each c in Form.Controls

'Test it and take some action
 
There is a vb project, it has many vb forms. In these forms one
database has been referenced and some tables/view/sp's are being used
to select/insert/update/delete data etc.

I want to make a list like this:

FormName: DB Object Used Type
=======================================================
MST00010 Order_dtl Table
MST00010 PO_List Table
MST00010 View_Vendor View
MST00010 sp_CheckLIstGen Stored Procedure
MST00010 spr_WirePart Stored Procedure
-------------------------------------------------------
MST00020 Order_dtl Table
MST00020 Employee_dtl Table
....... etc






I hope this will be helpful to understand the problem in detail


Thanx in Adv.

T.S.Negi
 
T.S.Negi said:
There is a vb project, it has many vb forms. In these forms one
database has been referenced and some tables/view/sp's are being
used to select/insert/update/delete data etc.

I want to make a list like this:

FormName: DB Object Used Type
=======================================================
MST00010 Order_dtl Table
MST00010 PO_List Table
MST00010 View_Vendor View
MST00010 sp_CheckLIstGen Stored Procedure
MST00010 spr_WirePart Stored Procedure
-------------------------------------------------------
MST00020 Order_dtl Table
MST00020 Employee_dtl Table
....... etc






I hope this will be helpful to understand the problem in detail
Click to expand...

Create a data access layer, e.g. a Database class wrapping all data access
jobs, and you'll only have to look at that layer to find them all.


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html
 
Back
Top