On Sep 22, 2008, at 2:18 PM, Uwe Grauer wrote:

> Please tell us why you would want to have CHAR(3) as your PK.
> I'm asking because i would use technical PKs whenever possible.
> If you need CHAR(3) as a unique key for lookups, just add a CHAR(3)
> field with a unique key constraint in addition to your technical PK of
> type NUMERIC(18,0) which is a BIGINT for Firebird.

        I don't believe that the question was one seeking information about  
database design.

        No matter what the type/size of the PK selected, there should be  
*some* way to enable manually entering and saving them, no matter how  
wise or unwise that practice may be. I plan on looking into this code  
this evening.

-- Ed Leafe





_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]

Reply via email to