RecordID Sequence

[cmcfarling]

Could someone explain to me why in world RecordID numbering jumps from 127 to 32768. I can't think of any logical explanation. Also, is there any way around this. Documentation on this is non-existent.

[yafreax]

Here's the explanation according to Filemaker Support Website article 104663. (Hey filemaker, sorry i just copied and pasted, but the article wasn't long enough to send him on a hunt for it).

Explanation:

The Status(CurrentRecordID) function was included in FileMaker Pro 4.0 and later primarily as an aid to web publishing and cgi functionality. It provides access to a unique ID that is specific to one record in the database regardless of the current found set or sort order.

(in contrast to the Status(CurrentRecordNumber) which changes based on these variables.) The ID numbers FileMaker Pro generates are sequential but not contiguous due to the way the numbers are generated internally. It is not intended to be used as an incremental serial number/counter, etc.

---End---

Honestly, i think that's a cheap way of trying to get away with internally screwing up, but whatever. Note this as well, which i didn't know until now, after 127, you know it goes to 32,768. Again it will increase by one until rec ID 49,151 then it will give you 12,582,912. And again, increase by one. . . Yeah, great explanation filemaker. Make since to me "we screwed up but we'll come up with a lame excuse to make sure we don't look stupid."

you only made matters worse. Admission would've atleast granted some respect.

Jeremy

------------------

Filemaker's kind of like a wife; easy to love, yet just so complicated.

[This message has been edited by yafreax (edited November 08, 2000).]