TCL Selections on some tables using indexed fields don't give any result.

The data is accessed by both OI(7.x) ans Arev(3.12) Clients.

Btree.extract on those fields work OK

A rebuild of the index doesn't fix the problem.

A solution is to remove all the indexes from the table and then reinstall all the indexes.

Is this caused by the mixed clients use?

Is there a simple solution for this problem?

Ed Keeman

We have been having a indexing problems on our Arev 3.12 system.

A TCL Select using an indexed field that worked yesterday, and often worked just a bit earlier in the day, will stop using the index. The TCL select will still return records, if you let it run for hours. Adding in CASEINSENS fixes the TCL, which makes little sense (pun!). But it does seem to work, all the time to.

The field that is indexed can even be numeric, like a date, and the addition of the CASEINSENS resolves the problem.

I have no idea if our problem is related to yours, but maybe being a little insensitive is just what the LH needs?

Perhaps both of you could give examples of the SELECT statement where you indicate which columns are indexed?

A typical problem with indexes is if a revelation delimiter gets into the key of the table. then, retrieval is offset or empty.

Dave

Perhaps both of you could give examples of the SELECT statement where you indicate which columns are indexed?

A typical problem with indexes is if a revelation delimiter gets into the key of the table. then, retrieval is offset or empty.

Dave

SELECT SERVICE WITH STATUS EQ "AGRO"

The field status has a btree index installed.

No delimitters in the keys.

collect.ixvals does return "AGRO" as an indexed value

btree.extract does give a list of keys.

This index is repaired by reinstall all indexes after removing all indexes from the table.

Never had this problem until OI-clients came along.

We also have a mfs on the table installed for charset conversions.

Can you elaborate on the MFS? How does it deal with ANSI-]OEM?

The Sprezzatura Group

World leaders in all things RevSoft

The Arev mfs is http://www.kee-man.com/oi/arev_mfs.txt

The OI mfs is http://www.kee-man.com/oi/oi_mfs.txt

The asciimfs is executed after si.mfs (revmedia record)

Sorry … no help with your problem …

An interesting strategy … do I understand it well … your DOS codding differs from Win codding? Or is there another reason for ascii conversion (crypting?).

We are in the situation when our DOS codding differs from the Win one,

especially when our common letters in Win codding equals @SVM,@VM.

If we would go for OI, we should fight with it in input screens …

Does anyone know feasible solution?

Looking at the 'conversation' on here, and from another thread a couple of weeks ago, is it possible that the CaseInsens Flag is set differently within Arev and OI ??

SysEnv record, position 90.

Simon

We are using a CHARMAP to allow OI to read and write AREV data successfully in French.

The Sprezzatura Group

World leaders in all things RevSoft

Indexing is a funny thing. Even though SI.MFS is called first, it actually processes the index values last.

So, what happens, in a rough manner

You write record.

SI.MFS gets called.

If OREC isn't cached, it's read using call @NEXTFS

The current values for the index are calulated using OREC

The record is written using call @NEXTFS

The new values for the index are calulated using using the record retuned through the @NEXTFS call.

The transaction values are writting to the ! file.

I think that somehow what you are writing and what you are searching for somehow end up being different. You'll need to search for the actual data written, not the data you passed in.

support@sprezzatura.com

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

CHARMAP, hummm.

Did'nt know that one.

How do i a implement charmap ?

Ed: I can see my answer/question redirects you:)

Sprezz: I have spent 3hours searching this forum …

it seems to be feasible … I can use my old AREV codding and input from the Win keyboard and output to the screen will be translated "on the fly". Do I understand it well?

Basically yes, we set the charmap on entry to the system and from thereon in enter in "Windows" store in "Dos".

The Sprezzatura Group

World leaders in all things RevSoft

View this thread on the forum...