Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

PK length

Questions related to using nuBuilder Forte.
Locked
Timo
Posts: 217
Joined: Thu Mar 15, 2018 9:26 pm
Has thanked: 1 time

PK length

Unread post by Timo »

I found this article: "Recommended Table Structure": https://wiki.nubuilder.net/nubuilderv3/ ... _Structure
We suggest the PK should be a varchar(25), as it will automatically be populated by nuBuilderPro using a nuBuilder function called nuID() (when filled out as below), unless the PK is an auto-incrementing number.
If a varchar(25) is used for the PK instead of a number it allows for better use of certain hash variables such as #nu_browse_filter#.
Assuming that this is also valid for nuBuilder Forte, I wonder why the PK length should be 25 although all (automatically generated) PK keys are only 15 characters in length.
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: PK length

Unread post by admin »

Timo,

Things might change in the future.

Steven
Timo
Posts: 217
Joined: Thu Mar 15, 2018 9:26 pm
Has thanked: 1 time

Re: PK length

Unread post by Timo »

Ok
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: PK length

Unread post by admin »

.
Locked