home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #1 / NN_1993_1.iso / spool / comp / database / 8903 < prev    next >
Encoding:
Text File  |  1993-01-07  |  1.2 KB  |  34 lines

  1. Newsgroups: comp.databases
  2. Path: sparky!uunet!spool.mu.edu!agate!dog.ee.lbl.gov!news!humu!pegasus!tleylan
  3. From: tleylan@pegasus.com (Tom Leylan)
  4. Subject: Re: Pls help: algorithm wanted (xbase, pref foxpro)
  5. Message-ID: <1993Jan7.212402.21752@pegasus.com>
  6. Organization: Pegasus,  Honolulu
  7. References: <1993Jan4.201319.9088@almserv.uucp>
  8. Date: Thu, 7 Jan 93 21:24:02 GMT
  9. Lines: 23
  10.  
  11. In article <1993Jan4.201319.9088@almserv.uucp> g9utxu@fnma.COM writes:
  12.  
  13. >I like this program, <...> But does it work...I tried using 
  14. >the following:
  15. >
  16. >RATE.DBF    Record   START_DATE    END_DATE   STATUS
  17. >               1      07/01/91     06/30/92   FINAL
  18. >               2      07/01/92     06/30/93   FINAL
  19. >               3      07/01/93     12/31/93   PROVL
  20. >               4      01/01/94     06/30/94   FINAL
  21.  
  22. Your results and the RATES.DBF indicate that you did not add the final
  23. "rest of time" record.  Add a 5th record from 07/01/94 - 12/31/99 that
  24. is uncovered.
  25.  
  26. By shifting that burden onto the database I was able to reduce the code
  27. size.  In your version (written more to spec perhaps) a "no find" meant
  28. that you still had to skip back one record to make certain that if it
  29. _really_ was a no find or if the search date was prior to the last
  30. record's END_DATE.
  31.  
  32. tom
  33.  
  34.