Re: Abbreviation List Tables Design, aka OTLT

We still use this sort of index.!! It works fantastically!... It's written
up automatically as the records that are indexed are saved, and builds
various b-tree type indexes up....

Regards
Simon
"Bruce Nichol" <reverse_ecurb@xxxxxxxxxxxxxx> wrote in message
news:e72jt1h78l0g2cv05gblgsvtjim5dd10du@xxxxxxxxxx
> On Thu, 26 Jan 2006 16:56:27 -0800, "Brian Bond"
> <brian@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>>(This post is slightly off-topic, since it concerns a cross-reference
>>rather
>>than an abbreviation list.)
>>
>>I encountered this beauty about twenty years ago. You can probably deduce
>>how it worked.
>>
>> SMITH
>>001 3
>>002 SMITH*BOB]324563
>>003 SMITH*MARVIN]53098
>>004 SMITH*STANLEY]443356
>>
>>
>>Probably not a good example of how use multi-values....
>>
>
> Ah! The old pre-BTree days....
>
> Can vaguely recall something similar....
>
> I inherited an indexing environment that started with a x-ref to the
> "index" file using the first 7 characters of the "input field", eg,
> "Surname", reducing the @ID by the "least significant" character until
> a "hit"... Then display all of the items in the "hit" for selection,
> or as happened as often as not, rejection........
>
> This one looks a bit more obtuse; seems as if you could enter 2
> fields, "Surname" and "First Name" and get one hit after the other....
> the 2nd value of each field being the @ID of the indexed file....
>
> Sorry, but actually, IMHO. this is not such a poor example of the use
> of multi-values, at all .... Saves doing a FIELD extraction or some
> such...
>
> Means you can have more than one "Bob Smith", too....
>
> And a little bit of data integrity checking with an apparant count of
> "used fields" in Field 1....
>
> 25 years ago, I'd have probably been just as proud of it as its
> author...
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURY NSW Australia
>
> http://www.taloncs.com.au
>
> If it ain't broke, fix it until it is....


.

Relevant Pages

  • Re: chester aftersales service
    ... I`ve had a nice email from Chesters and they are going to sort ... Best regards ... Stuff like the Adept lathes or some like the AA lathes from the US. ...
    (uk.rec.models.engineering)
  • Re: New Elliott Randall CD (EP) ...and GUITAR DAY at my place
    ... Thanks you for the compliments! ... next couple of months - cover art is ready, ... Lotsa research as this is a Brave New World as regards this crazy ... what I sort of expected, very tasteful, funky,still got a sort of ...
    (uk.music.guitar)
  • Re: Treeview Node Type
    ... I've done this sort of thing a variety of ways. ... and less troublesome in regards to managing parent object references ... of type group nodes that want to different things to. ... Regards, Chris. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: One Brave Jewish Woman
    ... Best regards, ... does not have any sort of middle eastern accent as ... Action Committees and ANSWER. ...
    (soc.culture.jewish.moderated)
  • Re: Filling in Blank Cells
    ... easier to then sort on this to bring any duplicates together. ... Regards. ... >>> Peo Sjoblom ...
    (microsoft.public.excel.newusers)
Loading