John Krussel <[log in to unmask]> writes:


> Since Image places records Serially (unless there is a delete chain) there
> is probably a very small chance that the same customer placed two orders
one
> right after another. In that case your test will almost always fail and
> you'll have to do the Find and the Get. If you read all the entries first,
> sort them by Cust# and then go through them again getting any additional
> data, there is a greater likelihood that you will already have the record
> you want in your buffer. And have to do less reading

Actually, since the invoices data set has the invoice number as its primary
key, I would expect to find all invoice records for a given invoice in the
same block (or as close as possible).  Since there are (usually) multiple
invoice records per invoice, I think the test would almost always be true
and I wouldn't have to have Image (or MPE) check anything, since I am
checking it in the program.


Jim Phillips                            Manager of Information Systems
E-Mail: [log in to unmask]     Therm-O-Link, Inc.
Phone: (330) 527-2124                   P. O. Box 285
  Fax: (330) 527-2123                   Garrettsville, Ohio  44231