The problem I have is that a non-Revelation application is feeding

the Revelation application with customers. Because of the nature of the overall system this cannot be changed. The non-revelation system

has like keys for like customers. For example, "012345" for customer "Jeff Miller" and "12345" for customer "Jeff Miller". Same name and

different but simular keys. When the records are brought into Revelation the indexing routine treats the 2 keys as if they are the same key. As a result when a lookup is done it returns only one of the keys. Is there a fix to this indexing problem? I do not want to recreate this indexing fuction.

Perhaps the simplest way would be to prepend the keys with an alpha character when you import the data.

Side Note: After an extensive discussion on alt.usage.english about the word append, there was a general consensus that prepend and postpend should be added to the lexicon. I use prepend occasionally and encourage its use, meaning, of course, to append to the beginning.

So here you are, making up new words when we have perfectly adequate options. Don't you like prefix? Do you have a problem with that? Geez, louise, what's with you people? Sometimes I don't know why I bother.

Gary

Yeah. I could have also used "begin" or a number of other words, but I like prepend. Prefix is usually used with words, whereas append is frequently used as a computer-related term. Append, however, is ambiguous, hence prepend.

Oh sure .. prefix prefix prefix .. you are probably one of those guys who cut in at the head of a line.

I am from a kindler and gentler world .. I would prefer to postfix

dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

If PostFix the same Suffix?

Depending on the version of ARev you are using, there is a UDC (User Defined Conversion) called NUMTOCHAR_CONV that you can use.

Place this in the input and output conversion and it automatically adds an 'x' to the front the of string for an ICONV and strips the first character for an OCONV. (For the pendantic amoungst you, we can use prepends or prefix).

I think this was first available in the 3.x series, but it might be undocumented and existing in 2.12.

Basically, it does Victor's original suggestion, but with very little work on your end.

akaplan@sprezzatura.com

Sprezzatura, Inc.

FYI: If you put a rightdex on a file and use the keys "012345" and "12345", the "012345" will not appear on lists when selecting the file. It matters not if there is an index (Relational, Btree or Cross Reference).

PS There was a simple question asked. This forum is for posting responses to someone's problems. Not showing how ignorant and childish you can be. Please GROW UP or go away!!!!!!!!!

Depends on what language you use .

dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

Dear Concerned Programmer;

]FYI: If you put a rightdex on a file and use the keys "012345" and "12345", the "012345" will not appear on lists when selecting the file. It matters not if there is an index (Relational, Btree or Cross Reference).

I believe that Arev looks at all "numbers" (don't even want to get into whether something is a number or not in arev as my response might be considered childish and I would be euthanatized as not having leading zeros, similar to all data being 'trimmed'.

]PS There was a simple question asked. This forum is for posting responses to someone's problems. Not showing how ignorant and childish you can be. Please GROW UP or go away!!!!!!!!!

Does PS stand for "please stop" or what?

dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

This forum is for posting responses to someone's problems. Not showing how ignorant and childish you can be. Please GROW UP or go away!!!!!!!!!

Yeah, well I'm rubber and you're glue so everything you say bounces off to me and sticks to you! So nannie-nannie-boo-boo!

Actually, me thinks Mr. Engle and Mr. Kaplan explained how to get around the problem, along with a Revelation Technologies supplied solution.. Terribly sorry the answer wasn't good enough, however, there are disadvantages to an un-typed language.

Could be worse. You could have an uppercase E embedded in an otherwise numeric key. I'd tell you what that means, but I'm way to childish to impart any useful information.

Gary Gnu

View this thread on the forum...