On Thu, August 23, 2012 1:42 pm, Paul McNett wrote: > Over the years of my experience with Fox and VFP, I used all kinds of > ways to generate primary keys, and in retrospect the best ever was > concatenating the machine name with the output of sys(2015). > > In my opinion, auto-incrementing integer keys are to be avoided. > > > I use 40-char GUID's in my Python work, but to get those in VFP you'd > have to rely on an external library which could slow you down compared to > VFP's sys(2015).
Neat tip. So how wide is your PK field using this approach? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
