Finding OpenInsight Table Used by Forms
If you have databound forms in OpenInsight and want to locate the forms bound to that table you can quickly find them with this query:
LIST SYSREPOSWINS TABLES WITH TABLES EQ 'YOUR_TABLE_NAME'
The result is a list of forms bound to the table.
What if you don't have a databound form? You can widen the search using this query:
LIST SYSREPOSWINS TABLES WITH ALL CONTAINING 'YOUR_TABLE_NAME'
The query searches the entire form for the occurence of the table name. It does this by using the built-in field ALL which represents the entire record.
Author
Jared Bratu
Long time network sysadmin with proclivity to coding. Why do something twice when it can be scripted once? With a wide range of familiar technology skills Jared tries to apply the best aspects of each technology to projects leaving them better than they were before.
Leave a comment