Re: [libreoffice-users] Other SQL question as it affects Base

I'm listening very closely.

Your strategy is based on the assumption that consecutive readings 
have consecutive primary keys.  Not even just being in the right 
order, they have to be consecutive integers for your strategy to 
work.  This elevates the primary key from "internal workings" to 
"data".  Your strategy is based on the specific values of those 
numbers.

That's not what table primary keys are intended for in the relational 
database model.

As I said in my previous post, it sort of works, and happens to work 
reliably enough for you in your situation.  That's fine.

You say you're a mathematician.  Does coincidental relationship bear 
mathematical scrutiny as a general strategy in that context?

Regards
Mark



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted