My understanding is that global dict items (symbolics) can be created within the SYSDICT table. The proceedure (OIv3.73) is to log into SYSPROG account and use the Table_Bulder tool to create the global symbolic.

However seems a MFS protects the SYS tables - so that the symbolic is not saved. Tried copying the syybolic (created in another dict.table) into the DICT.SYSDICT table. Copies ok but does not produce the desired result.

BTW anyone got documentation on SYSPTRS. I have used this before but forgotten / mislaid my notes.

Richard Bright

I may be wrong, but I think the global dictionary items are assigned when the application is created.

You might want to try backing up the application, deleting the application, create a new application and restoring from the backup.

Good-luck,

Richard Richter

Richard ..

I don't think so. I have added global dict items (particularly symbolics) in the SYSPROG application many times. These are inherited to by all other appications.

Don

[notag]Shouldn't that just be SYSDICT not DICT.SYSDICT?

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New (Thanks Mr Clark) <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>] [/notag] </QUOTE> —- === At 23 OCT 2001 11:00PM Richard Bright wrote: === <QUOTE>Say Don the catalyst for this question was a) your response to an earlier thread on the other side re tracking voc changes - Sync. dict items for application (you were commenting on functionality in AREV Dict ?) b) another query earlier about the features documented in the Works Catalogue viz: *—– Table Builder - New Feature 3.61 3.7

?The Table Builder allows system tables to be designed when logged into the SYSPROG application. (SYSOBJ/$LIST_TABLES_DICT)

?The Table Builder allows a global dictionary (SYSDICT) to be designed. This dictionary contains fields which supplement other dictionaries as if the fields existed in each dictionary. (SYSOBJ/$LIST_TABLES_DICT, SYSOBJ/$SWAP_DATABASE)

*—–

I seem to have hit a road block when I tried to explore this feature and am looking for the reasons why things are not working as I would expect.

Richard Bright

Guess so. Having said that, both SYSDICT and DICT.SYSDICT throw up the same record keys – seems like one acts as an alias of other?

Getting back to the issue -

1. Can I create a symbolic (using Table Builder – save symbolic in a temp dict table)– then copy Dict record to the SYSDICT table to achieve a global Dict?

2. Any other issues I have to be mindful of?

Richard Bright

[notag]You are correct re: alias.

To get a global dict item you need to copy an existing dictionary item to SYSDICT because SYSDICT does not have DICT.MFS installed so it will not compile a new entry as a dictionary entry.

We've just tested this with a dict item called COUNTER in DICT.LOG which essentially counts lines in a program. We Run Copy_Row "DICT.LOG","COUNTER","SYSDICT","COUNTER" then run Rlist "LIST SYSPROCS COUNTER",1 and get the expected listing.

No known issues - we use SYSDICT all the time in S/List when listing DICTs or when we can't find the corresponding dictionary item in the file being listed.

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New (Thanks Mr Clark) <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>] [/notag] </QUOTE> —- === At 24 OCT 2001 09:05AM Don Miller - C3 Inc. wrote: === <QUOTE>Or, if you're brave enough, remove the MFS from SYSDICT by diddling the media map. Then you can compile SYSDICT elements to your heart's content. Don </QUOTE> —- === At 24 OCT 2001 10:23AM The Sprezzatura Group wrote: === <QUOTE>[notag]There isn't an MFS on SYSDICT as evidenced by the fact that COPY_ROW can copy dictionary items in and system editor can save records in the table (but not compile as dictionary items - hence missing DICT.MFS). This must be an application level hack in the Table Builder. [<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>] [<I>World Leaders in all things RevSoft</I>] [<img src="http://www.sprezzatura.com/zz.gif">] [<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>]

[<FORM ACTION "" METHOD=GET NAME="TOCNavigator"

<SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()">

<OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go

<OPTION VALUE="http://www.sprezzatura.com">Home Page

<OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New

<OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL

<OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST

<OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura

<OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura

</SELECT>

</FORM>] [/notag]

Well .. well .. well. Checking confirms you're right (no MFS). Since I don't use Table Builder at all (I do all my DICT work in AREV 3.12) I never noticed it since that works hunky-dory. Egad .. what perchance lurks on OI32 when Table Builder may be the ONLY tool available with that? Eeeeeek. Maybe the wizards at RTI will fix some of the bugaboos in Table Builder as part of the deal. Would be nice, wouldn't it.

Don

[notag]Well, there was S/Dict…

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0"}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>][/notag] </QUOTE> —- === At 25 OCT 2001 06:06AM Richard Bright wrote: === <QUOTE>Global Dict stuff now works. Thanks. Interesting, checking round, seems many do their dicts in AREV (rather than OI) because they dont trust the Table_Builder. Guess we will have a new untarnished world with OI32. </QUOTE> View this thread on the Works forum...