Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

PK length

Questions related to using nuBuilder Forte.
Locked
Timo
Posts: 221
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: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: PK length

Unread post by admin »

Timo,

Things might change in the future.

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

Re: PK length

Unread post by Timo »

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

Re: PK length

Unread post by admin »

.
Locked