table usage

Project:Prolint Issue Tracker
Component:Rules
Category:task
Priority:normal
Assigned:Unassigned
Status:active
Description

Ho do we create a rule which will identify whether the program is using a DB table or not ?


Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#1

I have created a similar rule once, which will tell you all the tables and temp-tables being used in given program. Even if you have defined a buffer for the table with a different name, it will give you the actual name of that table. Sadly i am not having a copy of that program right now, but i can give you an idea on how to write one -

I have used existing rule tableusage (http://www.oehive.org/prolint/rules/tableusage) and created a new program for my rule and then used the XREF information to find out temp-tables and db tables.

hope this helps.

I'll write that code again and post after some time.

--
Ganesh