On 10/12/2010 8:28 AM, Simone Krais wrote:
Dear openoffice team,
I am trying to establish an open office database for my work as an
anthropologist. I need tables with the size of around 300 columns (data
fields). With the size of 127 I can not go on. Does this probelm has anything
to do with the type of the fields (INTEGER, TINYINT,...)? What is the problem?
Can you help me?
Thanks in forward,
kind regards,
Simone Krais
Simone, is the problem that you are having an issue with the number of fields that can be defined
for a specific table in Base? I've never needed as many as you're indicating, but I'd recommend that
you organize your data into multiple tables of related data, perhaps using the same primary key for
all of them if they don't naturally have their own. In many cases, there is a great deal of
duplication of data when tables (or spreadsheets, for that matter) get very wide, making it much
harder to update everything in sync.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
