AnsweredAssumed Answered

Discrepancy between Get(RecordID) and AppleScript record ID

Question asked by andreb on Oct 20, 2013
Latest reply on Oct 22, 2013 by andreb

Title

Discrepancy between Get(RecordID) and AppleScript record ID

Post

     Using FileMaker Pro Advanced 11 on Snow Leopard.

     Why does the result of Get(RecordID) differ from the result returned when the same request is made using AppleScript?

     More specifically, the results seem to be the same up to the 127th record. From 128th record on, the record IDs differ.

     In spite of that, telling AppleScript to show a particular record using any ID returned beyond the 127th record still works,

     This example code shows record IDs for the first 165 records returned by AppleScript:

      

getIDofeveryrecordofwindow "RecordID" ofdatabase "RecordID"

--> {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0, 16.0, 17.0, 18.0, 19.0, 20.0, 21.0, 22.0, 23.0, 24.0, 25.0, 26.0, 27.0, 28.0, 29.0, 30.0, 31.0, 32.0, 33.0, 34.0, 35.0, 36.0, 37.0, 38.0, 39.0, 40.0, 41.0, 42.0, 43.0, 44.0, 45.0, 46.0, 47.0, 48.0, 49.0, 50.0, 51.0, 52.0, 53.0, 54.0, 55.0, 56.0, 57.0, 58.0, 59.0, 60.0, 61.0, 62.0, 63.0, 64.0, 65.0, 66.0, 67.0, 68.0, 69.0, 70.0, 71.0, 72.0, 73.0, 74.0, 75.0, 76.0, 77.0, 78.0, 79.0, 80.0, 81.0, 82.0, 83.0, 84.0, 85.0, 86.0, 87.0, 88.0, 89.0, 90.0, 91.0, 92.0, 93.0, 94.0, 95.0, 96.0, 97.0, 98.0, 99.0, 100.0, 101.0, 102.0, 103.0, 104.0, 105.0, 106.0, 107.0, 108.0, 109.0, 110.0, 111.0, 112.0, 113.0, 114.0, 115.0, 116.0, 117.0, 118.0, 119.0, 120.0, 121.0, 122.0, 123.0, 124.0, 125.0, 126.0, 127.0, 3.2768E+4, 3.2769E+4, 3.277E+4, 3.2771E+4, 3.2772E+4, 3.2773E+4, 3.2774E+4, 3.2775E+4, 3.2776E+4, 3.2777E+4, 3.2778E+4, 3.2779E+4, 3.278E+4, 3.2781E+4, 3.2782E+4, 3.2783E+4, 3.2784E+4, 3.2785E+4, 3.2786E+4, 3.2787E+4, 3.2788E+4, 3.2789E+4, 3.279E+4, 3.2791E+4, 3.2792E+4, 3.2793E+4, 3.2794E+4, 3.2795E+4, 3.2796E+4, 3.2797E+4, 3.2798E+4, 3.2799E+4, 3.28E+4, 3.2801E+4, 3.2802E+4, 3.2803E+4, 3.2804E+4, 3.2805E+4}

      

      

     Get(RecordID) calculates the IDs of the same 165 records in consecutive order: record 1=recordID 1, record 2=recordID2 . . . record 165=recordID165
      
     Yet telling AppleScript to show record ID 32768 produces record 128, but telling AppleScript to show record ID 128 results in an object not found error.
      
     What's going on?

Outcomes