OI and Quickdex for Cameron (OpenInsight Specific) [Revelation On-Line Wiki]

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

At 29 DEC 1997 03:28:31PM Jane Doogue wrote:

OpenInsight Specific

Cameron,

Thanks for your answer. However, the Quickdex question was missed:

I have tables which are accessed by both ARev3 and IO.

However, I cannot add new fields under OI - The Add Data Column option is suppressed.

Under ARev I sometimes get the message:

You cannot write or delete rows because the Quick/Rightdex for this table does not use 'CM_ISO' language set specified in the current environment.
                  Either:
                  Reload the 'Default' language set
                  Or:
                  Re-install the Quick/Rightdex
I have done both but still get the message. Only when there is no Quickdex is it possible to add new fields, but then only in ARev.

The files were originally copied from ARev1.

Any ideas?

Does indexing need to added/rebuilt in both ARev3 and OI even though the files are being shared?

How is Quickdex aded in OI?

At 29 DEC 1997 09:41PM Cameron Revelation wrote:

Jane,

the Quickdex question was missed

I am not sure of the answers

Under ARev I sometimes get the message "You cannot write or delete rows because the Quick/Rightdex for this table does not use 'CM_ISO' language set specified in the current environment."

Check:

1) In OI, edit the environment record (ENV_ in the SYSENV table) and set the language set field 15 (ENV_LND_DEFAULT$ from the insert record ENVIRON_CONSTANTS) to blank (which is the deafult).

2) In Arev do the equivalent. (Unfortunately I don't have Arev handy where I am at so I am not sure that the steps are the same.)

After doing the above, log out and back in. Then drop and re-build the index. At this point, the index should be sorted using the default (byte) ordering.

How is Quickdex aded in OI?

Look up Set_MFS in the BASIC+ online help. (Open System Editor, choose File, New, Stored Procedure, type "Set_MFS", move the edit cursor to the word "Set_MFS" that you just typed, and press F1.) It has an example of installing RightDex on a table. You can always do it from the command line like:

run Set_MFS '', 'QUICKDEX.MFS', 3

Remember, the Set_MFS program changes the REVMEDIA for the volume containing the table and it changes the SYSVOLUMES and SYSTABLES (memory resident filing system) but it does NOT save the database definition. After adding/removing MFS's using Set_MFS, remember to go to Database Manager and choose "Save" from the "Database" menu.

Cameron Purdy

Revelation Software

View this thread on the forum...