OpenEuphoria

Re: EDS request

• Posted by Kat <gertie at ZEBRA.NET> Mar 17, 2000
• 406 views

>
> ----- Original Message -----
> From: "Mike Sabal" <MikeS at NOTATIONS.COM>
> To: <EUPHORIA at LISTSERV.MUOHIO.EDU>
> Sent: Friday, March 17, 2000 12:25 PM
> Subject: EDS request
>
>

> As for db_get_key, what I am looking for is the ability to pass in a
partial
> key, and return the first key that matches.
>
> db_next_key would simply return whatever the next key after the given key
> is.
>
> The problem is this: say I have the following keys:
>
> 011234567BLA
> 011234567WHI
> 011234567BLU
> 011234567RED
> 012345678BLA
>
> I want to get all the records whose keys start with "011234567".  If I
don't
> know the last three letters, I can't get the key.  Trying to do a random
> search is unrealistic.  And if I use the record numbers, a linear search
is
> too slow, and the records are unsorted.  Any help (or revisions) would be
> appreciated.

Wouldn't it be a good idea to have access to the key list and the
applications that own them? That way you could concieveably tell the DB that
since some application crashed, it should unlock the section it had locked.
Same for if a application locks a section, crashes, restarts, and wants
access to that section again.

Kat