Re: EDS request
- Posted by Robert Craig <rds at ATTCANADA.NET> Mar 17, 2000
- 420 views
Mike Sabal writes: > 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". Use: db_find_key("011234567") db_find_key("012345678") These will both fail, but they will both return a negative number that indicates the position that these keys would occupy in the table if they were inserted. Use these negative results to set up a for loop, e.g. a = -a b = -b for rec = a to b-1 do ... end for db_find_key() uses binary search, so it's quite fast. This feature wasn't documented very well. Regards, Rob Craig Rapid Deployment Software http://www.RapidEuphoria.com