To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43529
------- Additional comments from [EMAIL PROTECTED] Sat Mar 5 00:07:32 -0800 2005 ------- Hi Frank, I've just tested with Beta2.0bc and the problem remains. :-(( Server version : 4.0.20 I can't dump the data in the base because its confidential (I'm a lawyer remember ;-)). What I can do is give you an explain statement of the structure : explain PROFCON +------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+----------------+ | address_id | int(10) unsigned | | PRI | NULL | auto_increment | | LNAME | varchar(35) | YES | | NULL | | | FNAME | varchar(35) | YES | | NULL | | | TITLE | varchar(35) | YES | | NULL | | | COMPANY | varchar(75) | YES | | NULL | | | COADDR1 | varchar(35) | YES | | NULL | | | COADDR2 | varchar(35) | YES | | NULL | | | COADDR3 | varchar(50) | YES | | NULL | | | COCITY | varchar(35) | YES | | NULL | | | COSTATE | varchar(35) | YES | | NULL | | | COZIP | varchar(12) | YES | | NULL | | | COCOUNTRY | varchar(35) | YES | | NULL | | | SALUT | varchar(20) | YES | | NULL | | | CUSTOM3 | varchar(35) | YES | | NULL | | | TEL1 | varchar(40) | YES | | NULL | | | FAX1 | varchar(40) | YES | | NULL | | | FAX2 | varchar(40) | YES | | NULL | | | MOBILE | varchar(40) | YES | | NULL | | | EMAIL | varchar(75) | YES | | NULL | | | WEBSITE | varchar(75) | YES | | NULL | | | NOTES | mediumtext | YES | | NULL | | | Type | tinyint(3) unsigned | | | 0 | | +------------+---------------------+------+-----+---------+----------------+ The SHOW CREATE TABLE command give this : CREATE TABLE `PROFCON` ( `address_id` int(10) unsigned NOT NULL auto_increment, `LNAME` varchar(35) default NULL, `FNAME` varchar(35) default NULL, `TITLE` varchar(35) default NULL, `COMPANY` varchar(75) default NULL, `COADDR1` varchar(35) default NULL, `COADDR2` varchar(35) default NULL, `COADDR3` varchar(50) default NULL, `COCITY` varchar(35) default NULL, `COSTATE` varchar(35) default NULL, `COZIP` varchar(12) default NULL, `COCOUNTRY` varchar(35) default NULL, `SALUT` varchar(20) default NULL, `CUSTOM3` varchar(35) default NULL, `TEL1` varchar(40) default NULL, `FAX1` varchar(40) default NULL, `FAX2` varchar(40) default NULL, `MOBILE` varchar(40) default NULL, `EMAIL` varchar(75) default NULL, `WEBSITE` varchar(75) default NULL, `NOTES` mediumtext, `Type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`address_id`) ) TYPE=MyISAM The table is DYNAMIC HTH, Alex --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]