https://bugs.freedesktop.org/show_bug.cgi?id=66171

--- Comment #4 from Alex Thurgood <[email protected]> ---
So I set up my own test db using the table definitions provided in your hsqldb
file and created a corresponding form manually (because the wizard is broken at
the moment).

I can not reproduce your problem on my master build on OSX :

Version: 4.2.0.0.alpha0+
Build ID: 51c79f97a90eaf469d1d2531f3f0eccfafe0f94c

FWIW, here are my mysql table definitions :

CREATE TABLE `currency` (
  `CurrencyCode` varchar(3) NOT NULL,
  `CurrencyName` varchar(40) NOT NULL,
  `Default` tinyint(3) NOT NULL,
  `Base` tinyint(3) NOT NULL,
  `DefaultRatetoBase` decimal(10,0) NOT NULL,
  PRIMARY KEY (`CurrencyCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


CREATE TABLE `Ac` (
  `bid` int(10) NOT NULL AUTO_INCREMENT,
  `Ac` varchar(100) DEFAULT NULL,
  `cur` varchar(3) NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1


Then I copied over the data from your hsqldb tables to my mysql tables using
the Append data function from the Copy Table Wizard that starts when you drag
and drop one table to another db. This fails BTW if you don't append the db
alias of the new table before the table name in the wizard dialog, I will see
if there is already a bug report for that.

Next I set up my main form to be based on table Ac, and then substituted cur
for a combobox using the following SQL query :

SELECT CurrencyCode from test.Currency

with SQL as the "Type of List Contents"

and set the properties of the combobox to be dropdown.

On testing, this works for me.


Alex

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to