Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Primary Key Maximum value



On 20.03.2007, at 13:45, Mike Schrag wrote:

[FrontBase]
sql = "SELECT UNIQUE FROM " + quoteTableName (eoentity.primaryKeyRootName());

AFAIK: This will not return a long value, as "select unique" on FrontBase is limited to integer.


With PostgreSQL long keys work for me. PK generation is more or less different in nearly every setup (EO_PK_TABLE in OpenBase and MySQL, sequences in PostgreSQL, select unique in FrontBase, you name it).

So - if you need BIG keys, use either a database where the plugin (and the db of course) supports long keys, or use 24 byte binary keys from EOF.

cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden
References: 
 >Primary Key Maximum value (From: Miguel Arroz <email@hidden>)
 >Re: Primary Key Maximum value (From: Robert Walker <email@hidden>)
 >Re: Primary Key Maximum value (From: Mike Schrag <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.