Pervasive
Sign in | Join | Help
in

Wrong Record returned on secondary key start/read

Last post 06-26-2008 8:24 AM by jpruneda. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-26-2008 2:09 AM

    Wrong Record returned on secondary key start/read

    At first I thought this was my application, but I'm getting the same results with Function Executor.

    Key 1 starts with four TinyInt fields representing a date in CYMD format.  So the Century 20 would be a >14.  If I try to do a start on >140000, the function exec returns a record that has a >46 in that position.  However, if I use the get first followed by next the records display in the correct order.  I just can't seem to jump into the middle of the file on this key

     Other keys seem to have to same problem.  I've rebuilt the file.  What else should I try?

     Thanks!

    Brent

  • 06-26-2008 8:24 AM In reply to

    Re: Wrong Record returned on secondary key start/read

    I tried it with file having the stat below and was able to get to the correct record using operation 9 (GE).  Can you provide a stat?  I tried it with version 10 of our product.

    File Statistics for c:\flags\test2.mkd

    File Version = 9.00
    Page Size = 4096
    Page Preallocation = No
    Key Only = No
    Extended = No

    Total Number of Records = 5
    Record Length = 4  
    Record Compression = No
    Page Compression = No
    Variable Records = No

    Available Linked Duplicate Keys = 0
    Balanced Key = No
    Log Key = SYSKEY
    System Data = Yes
       SYSKEY Status = Present
    Total Number of Keys = 1
    Total Number of Segments = 4

    Key         Position        Type            Null Values*               ACS
        Segment          Length           Flags              Unique Values
      0    1         1       1  Integer     RMD     --                 5    --
      0    2         2       1  Integer     RMD     --                 5    --
      0    3         3       1  Integer     RMD     --                 5    --
      0    4         4       1  Integer     RMD     --                 5    --

Page 1 of 1 (2 items)
© 2008 Pervasive Software Inc. All Rights Reserved.