Results 1 to 5 of 5

Thread: Max recnum

  1. #1
    Join Date
    Mar 2009
    Location
    Edmonton Canada
    Posts
    722

    Default Max recnum

    I have 5 to 6 years before a table at a client site hits recnum 99,999,999

    Its a Time Stamp table with approximately 18 rows per shipment. There have been 4,000,000 shipments since the system was installed 20 years ago.

    Currently it is at recnum 75,727,737
    It uses the Native Dataflex database.

    Nah, just kidding, it uses MS SQL 2016 ;-)

    Question:
    What happens when it wants to save recnum 100,000,000?
    I would not object to it starting at recnum one overwriting the existing stuff. 25 years of record retention should be just fine.

    No rush, but its nice not to leave these things until it happens.

  2. #2
    Join Date
    Feb 2009
    Posts
    1,018

    Default Re: Max recnum

    In SQL recnum is implemented as an integer with a max value of 2,147,483,647.
    So still a couple of centuries to go...


    Best regards,
    Data Access Worldwide

    Martin Moleman

  3. #3
    Join Date
    Feb 2009
    Location
    South Florida
    Posts
    3,474

    Default Re: Max recnum

    depends on what you do

    The video Gangnam Style forced youtube to upgrade its hit counters to 64 bit ... ;-)
    Michael Salzlechner
    StarZen Technologies, Inc
    http.://www.starzen.com

    Development Blog
    http://www.salzlechner.com/dev

    DataFlex Package Manager (aka Nuget for DataFlex)
    http://windowsdeveloper.com/dfPackage

  4. #4
    Join Date
    Feb 2009
    Location
    Castlegar, BC Canada
    Posts
    3,499

    Default Re: Max recnum

    So still a couple of centuries to go...
    Better get planning for this Archie LOL

  5. #5
    Join Date
    Feb 2009
    Location
    Cayman
    Posts
    2,573

    Default Re: Max recnum

    Quote Originally Posted by starzen View Post
    depends on what you do

    The video Gangnam Style forced youtube to upgrade its hit counters to 64 bit ... ;-)
    and THAT is the best fact I've learned this week!
    test? it compiles doesn't it?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •