Sorry for not being clear. It isn't the field size of 254 bytes that is of issue. To use the Database program, I need 255 fields and there is a limit of 120.
DKT -----Original Message----- From: Michael Adams [mailto:[EMAIL PROTECTED] Sent: Sunday, October 15, 2006 8:39 PM To: [email protected] Cc: [EMAIL PROTECTED] Subject: Re: [discuss] Re: Open Office Database On Mon, 16 Oct 2006 08:07:46 +1000 David Wilson wrote: > Dale, > > The limit for the varchar field type is 254 bytes (or characters), if > you want a bigger field for text use the memo longvarchar field type - > it has a limit of 65535 bytes. > > For some instructions on how to change database field types and > lengths for the bibliographic database see - > http://bibliographic.openoffice.org/files/documents/124/1284/HOWTO-increaseF ieldSizes-V2.odt > > regards > > David > > On Saturday 14 October 2006 1:47 am, Dale Tennison wrote: > > I see there is a limit of 125 fields in the open office database. I > > would really prefer to use the open office database for a > > propsective 800+ clients, but I need to have up to 250 fields. > > Please consider this expansion when appropriate. > > Fields per table. Heck that would slow it down. Cant you use multiple tables? If you really do need this many you could link tables by id columns to make as many fields as you need. Of course this is my MySQL background speaking here. I really suspect we are thinking a bad data base design. -- Michael Those that can, do; those that can't, teach. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
