{{tag>category:"OpenInsight 32-bit" author:"cmeyer" author:"Carl Pates"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Forms with missing dictionaries (OpenInsight 32-bit) ====
=== At 12 OCT 2020 02:48:51AM cmeyer wrote: ===
 
 
<QUOTE>
In preparation for implementing OI10.0.8.1 I am cleaning up my database(s). In doing so, I notice that some client data do not have the full complement of dictionaries as I would have made the form changes using another client data.

I would like to update all the client databases with the missing dictionaries.

Is there a way of listing the missing dictionaries used in forms similar to the error list when converting OI9.4 to OI10.0.8.1.



Any advice would be appreciated.



Chris
</QUOTE>
----

=== At 12 OCT 2020 05:11AM Carl Pates wrote:  ===

<QUOTE>Chris



You could write a program to scan through the SYSREPOSWINS records to check.  The structure of these records is described here:



   [url=https://www.sprezzatura.com/library/whitepapers/SprezzTB1.pdf]https://www.sprezzatura.com/library/whitepapers/SprezzTB1.pdf[/url]



Basically you get the @fm'd list of controls from the record ( field( winrec, @rm,3 ) ) and look in the POS_TABLE$ and POS_COLUMN$ values of each control (equates are in OIWIN_EQUATES).  Bear in mind these values can be @svm delimited for EditTables.



[email=cpates@revsoft.co.uk]Carl Pates[/email]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=303CA5E91E448F4E9391401E25B43E0A|View this thread on the Works forum...]]