Eurico Chagas Filho wrote: > Hi > > Sounds great, but... > In real life sometimes I need to edit a record, or add one to a table. > If I am using a feed from a seed table, I have more control of the records. > I can know what comes next or analyze the gaps, among other things. > > It is great when you need to create a test data, because the numbers r > smaller. > It's not advised but if you want to use the primary key as an access key, > people > will remember the numbers easily. > > HTH, E.
Never have the PK be a human-recognizable key. The PK should be internal, that's why I suggested the autoincrement integer field for the PK. Create some other fields if you want something human-readable but that's not good practice for the PK. ymmv. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
