Old Problem revisited (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== Old Problem revisited (OpenInsight Specific) ====
=== At 18 DEC 2000 12:06:23PM Don Miller - C3 Inc. wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
A long time ago, reported the "Dictionary is Read Only" error.  Generalized fix was to go into AREV and delete DICT.TEMP_.  This usually fixed it.  Now the problem has resurfaced but with a new wrinkle:

The table is GLOBAL (owner) PAYDATA.  I have two environments in which we do development:

SPT and SPTPLUS (this inherits from SPT) which has additional Forms and Stored Procedures and UI components.

I can open PAYDATA from SPT in Table Builder just fine.  However, from SPTPLUS, I get the Dictionary is Read Only error.  Sure enough at this point, there is a DICT.TEMP_PAYDATA around even though in between the two sessions I logged completely out of SPT before starting SPTPLUS.



Any ideas??
</QUOTE>
----

=== At 18 DEC 2000 03:28PM WinWin/Revelation Support wrote:  ===

<QUOTE>Don:



Not sure what you did - abnormal exit from form or table designer, but it sounds like the temp file exists in SPTPLUS, is not detected by SPT.  Solution remains the same, find, delete the table.



Hope this helps.



Bob

</QUOTE>

----

=== At 18 DEC 2000 03:35PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Mike ..

That's what I originally thought.  I tried the following:

Loaded up AREV and deleted the DICT.TEMP_TABLENAME.  For sure not there.

Fired up OI  - Account SPTPLUS Userename SPTPLUS.  Go to database manager and make sure the table is there.  Double-click on the raw table (not the DICT.TABLENAME).  Sure enough all the fields are there.  Double click on a fieldname to load table builder for it and lo and behold the Read Only error appears.  OK, sez I, go back into AREV and ZAP the DICT.TEMP_whatzis.  Go into SPT the same way and whoopsie-do, it works perfectly.  There's got to be something in the Repository for SPTPLUS that's doing it.  In fact, it doesn't matter if I copy SPT.DBT on top of SPTPLUS.DBT.  Same old same old.  Kinda crappy, no?



Don Miller

C3 Inc.

</QUOTE>

----

=== At 18 DEC 2000 03:44PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Mike .. et al.

The SPTPLUS.DBT table contained only a relative path to the data tables (without a drive letter).  Instead of the pointer being *F:\OIDATA\SPT it was *\OIDATA\SPT.  Interesting that it will attach and use the table properly.  It just won't let the tools function on it.  Using the editor to modify the .DBT fixed the problem and it hasn't returned.



Don Miller

C3 Inc.

</QUOTE>

----

=== At 19 DEC 2000 10:22AM Bob Carten wrote:  ===

<QUOTE>Thanks Don.





Al 

</QUOTE>


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