On 29/03/2012 14:25, jakefeed wrote: > > We have an database in which we supply product catalogs with pricing. > The end user can create their own items, too. In order to separate the > user's items from the items we supply, we're contemplating using > negative primary keys for our items and positive primary keys for the > users items. We are using Firebird 2.5.1. Are there any known issues > using negative primary key values in this configuration. Thank you. > If this is your database (?) if so, its a lot easier to add a new field which you can control with a domain such as a YES/NO on a field called Our_Product_YN. The default of the domain could be 'Y' or 'N' according to your needs. That way you just have one PK on Product_No and Our_Product_YN. Much simpler to maintain. HTH Alan
[Non-text portions of this message have been removed]
