To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46519
------- Additional comments from [EMAIL PROTECTED] Wed Apr 13 07:24:32 -0700 2005 ------- This time, it's only the "customer", "groups" and "invdet" tables that are accessible. These tables are defined as follows: CREATE TABLE `customer` ( `Customer` varchar(4) NOT NULL default '', `Name` varchar(30) NOT NULL default '', `Address1` varchar(30) NOT NULL default '', `Address2` varchar(30) NOT NULL default '', `Address3` varchar(30) NOT NULL default '', `Address4` varchar(30) NOT NULL default '', `Phone` varchar(12) NOT NULL default '', `Price` tinyint(1) unsigned NOT NULL default '0' COMMENT '1..6', `DateCreated` date default NULL, `Contact` varchar(20) NOT NULL default '', `DiscountPC` float NOT NULL default '0', `CreditLimit` int(10) unsigned NOT NULL default '0', `DDMandate` date default NULL, `DDStatus` char(1) default NULL COMMENT 'null: don''t DD; F: first DD not done yet; S: 2nd DD not done yet; D: 2nd DD has been done', `DDName` varchar(18) default NULL, `DDBranch` varchar(6) default NULL, `DDAccount` varchar(8) default NULL, `ExtraMonthsCredit` tinyint(1) unsigned default NULL, `DisputedItems` int(10) unsigned default NULL, `VatExemption` varchar(12) default NULL, `LabelAddress` varchar(200) default NULL, `Turnover1` int(11) default NULL COMMENT 'redundant', `Turnover2` int(11) default NULL COMMENT 'redundant', `Turnover3` int(11) default NULL COMMENT 'redundant', `Turnover4` int(11) default NULL COMMENT 'redundant', `Turnover5` int(11) default NULL COMMENT 'redundant', `Turnover6` int(11) default NULL COMMENT 'redundant', `Turnover7` int(11) default NULL COMMENT 'redundant', `Turnover8` int(11) default NULL COMMENT 'redundant', `Turnover9` int(11) default NULL COMMENT 'redundant', `Turnover10` int(11) default NULL COMMENT 'redundant', `Turnover11` int(11) default NULL COMMENT 'redundant', `Turnover12` int(11) default NULL COMMENT 'redundant', `Dead` set('1') NOT NULL default '', `temp` tinyint(4) default NULL, `RedirectAccount` varchar(4) default NULL, `AutoEmail` varchar(255) default NULL, PRIMARY KEY (`Customer`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `groups` ( `GroupNo` tinyint(2) unsigned NOT NULL default '0', `Description` char(25) default NULL, PRIMARY KEY (`GroupNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=100 CREATE TABLE `invdet` ( `TranRef` mediumint(6) unsigned NOT NULL default '0' COMMENT '<100000 = quotation', `Seq` int(11) NOT NULL auto_increment, `product` char(4) NOT NULL default '', `Description` char(25) NOT NULL default '', `price` int(10) unsigned NOT NULL default '0', `unitsize` tinyint(2) unsigned NOT NULL default '0', `quantity` smallint(6) NOT NULL default '0', `quantityinners` tinyint(2) NOT NULL default '0', `totalvalue` int(11) NOT NULL default '0', `vatcode` tinyint(1) unsigned NOT NULL default '0', `TranDate` date NOT NULL default '0000-00-00' COMMENT 'redundant', `Customer` char(4) NOT NULL default '' COMMENT 'redundant', `Cancelled` set('1') NOT NULL default '' COMMENT 'redundant', PRIMARY KEY (`TranRef`,`Seq`), KEY `CustDateProdIndex` (`Customer`,`TranDate`,`product`), KEY `ProdDateCustIndex` (`product`,`TranDate`,`Customer`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Here are the definitions of a couple of the other tables that have never been accessible, but which no other applications (including OOo 1.1 as far as I remember) have ever had any problems with: CREATE TABLE `dockets` ( `Docket` mediumint(6) unsigned NOT NULL default '0', `ScanDate` date NOT NULL default '0000-00-00', `ImageSize` mediumint(9) NOT NULL default '0', `CompressedImage` mediumblob ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `products` ( `Product` char(4) NOT NULL default '', `Description` char(25) default NULL, `GroupNo` tinyint(2) unsigned default NULL, `UnitSize` tinyint(2) unsigned default NULL, `Cost` int(10) unsigned default NULL, `VatCode` tinyint(1) unsigned default NULL, `Price1` int(10) unsigned default NULL, `Price2` int(10) unsigned default NULL, `Price3` int(10) unsigned default NULL, `Price4` int(10) unsigned default NULL, `Price5` int(10) unsigned default NULL, `Price6` int(10) unsigned default NULL, `Location` char(6) default NULL, `ShelfLife` tinyint(1) unsigned default NULL, `DateCreated` date default NULL, `Discontinued` set('1') NOT NULL default '', `ServiceOrCharge` set('1') NOT NULL default '', `Supplier` char(4) default NULL, `temp` tinyint(4) default NULL, PRIMARY KEY (`Product`), KEY `GroupIndex` (`GroupNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `supnotes` ( `Seq` smallint(6) NOT NULL default '0', `Supplier` varchar(4) NOT NULL default '', `NoteDateTime` datetime default NULL, `Author` varchar(20) default NULL, `KeepUntil` date default NULL, `NoteText` varchar(255) default NULL, PRIMARY KEY (`Seq`), KEY `Supplier` (`Supplier`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Thanks. --------------------------------------------------------------------- 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]