>Hiya Craig ---
>
>>
>>How much space does it take to store your GUID? Integers are small and VERY fast. Faster than character.
>
>See my reply to Erik...it's not that I have a problem with integer keys, conceptually, it's just that they have to be managed at the program level in VFP and not internal to the database engine, therefore, the potential for conflict exists.
I've never had a conflict. If you want to see how I implement them, look at the article on primary keys on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer