Highest record number used?

[John Esak]

What would be worng with using numrecs()


John

  -----Original Message-----
  From: filepro-list-bounces+john=valar.com at lists.celestial.com
[mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On Behalf Of
Mike Schwartz
  Sent: Wednesday, January 31, 2007 11:10 AM
  To: 'Fplist (E-mail)'
  Subject: Highest record number used?


       One of my customers was wondering if there is a way to quickly find
the highest record number (either allocated or in use) in a filePro file.



       If he could do a lookup to record number 9999999 with a "less than"
option, he says that would work perfectly for him.



       He wants to use it to trigger some file trimming processes and to do
some hour-by-hour error message logging.  If he could easily get hold of the
highest record number on each file, he could write one generic process to
monitor the daily change in number of records on each of his thousands of
qualifier files.



       I suggested doing a few repeated lookups for a certain record number,
then see if that number fails, then decrement that number by 1000 or so and
try it again, but he would have to establish and monitor some starting point
for each file so that the system doesn't have to do thousands of unnecessary
lookups.



  Thanks!



  Mike Schwartz


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20070131/3144ba3e/attachment.html