nuBuilder Forum

I'm a bit confused about the right approach to defining and using primary keys in nuBuilderPro.
Can I use auto-incrementing integers for all primary keys? If so, is there a catch?
Is varchar() a recommendation or the better option?
If I have a hidden internal client_id PK can I enforce a unique numeric or alphanumeric business-side client_ref with a unique index?
Any other pearls of wisdom gratefully received.

Regards
John

John,

We strongly suggest using varchar(25) for all Primary Keys.

Here are some reasons.. http://nubuilder.blogspot.com.au/2010_0 ... chive.html

nuBuilder will automatically populate PKs.

Steven