>>Has anyone beta tested this feature with existing integer Primary keys in which there were already records?
>>
>>Can anyone give me the skinny on how this works? (Behind-the-scenes stuff.)
>>
>>Thanks in Advance.
>
>There is a tiny mouse cage. In the cage is a spinning wheel. There is also a lepracan. When you add a record the lepracan temps the mouse with a piece of magic cheese. This causes the mouse to run in the wheel, and VFP counts the wheel rotations. The lepracaun just knows by magic when to give the mouse the cheese... so, you get the next id.
>
>Actually, I believe a few bytes unused in the .dbf header was stolen to store the next id value. If you already have values, when you change the type to auto-increment you can specify the 'next id' so it wont conflict with your existing numbers.
>
>BOb
Were I Irish I would have known that you were pulling my leg - Lepracauns, an Irish friend tells me, would only promised the cheese to the mouse and not actually given the mouse any.
Thanks for the info, Bob.
-Gil
Gil Munk
"If a nation expects to be ignorant and free, it expects what never was and never will be." - Thomas Jefferson