[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]] ==== SCAN_REP - Uses and Used by (OpenInsight Specific) ==== === At 29 APR 1998 09:21:09AM Jeff Word wrote: === {{tag>"OpenInsight Specific"}} This is a super utility! Nice work RTI. When I use the SCAN_REP options to validate Uses and Used by, does it actually go out and do the work that each area would do to relate items? (confused yet?) For example, when I save a report I assume it is storing the table name in the Uses and updating the table by placing the report in the Used by. So does SCAN_REP only verify what is in Uses and Used by or does it actually "update" Uses and Used by? I have some tables that do not show they are used by a report even though the really are. We need to rely on Uses and Used by. Are there any relationships that are not maintained or are not trustworthy? ---- === At 30 APR 1998 07:18AM Cameron Revelation wrote: === Jeff, [i]This is a super utility! Nice work RTI.[/i] Hey, thanks! [i]So does SCAN_REP only verify what is in Uses and Used by or does it actually "update" Uses and Used by?[/i] It does not re-evaluate the entity to determine the uses/used by; rather, it uses the information already there and makes sure that all references are mutual and to legal, existing entities. BTW The source is included, if you are really curious ;-) Cameron Purdy info@revelation.com ---- === At 30 APR 1998 07:35AM Jeff Word wrote: === All our reports are based on tables. Some reports do show the proper tables in the "Uses" and others do not show a table at all. How can we re-establish these missing relationships? [[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=849A17FA9684CBA8852565F500495901|View this thread on the forum...]]