https://bugs.freedesktop.org/show_bug.cgi?id=66171
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #20 from Lionel Elie Mamane <[email protected]> --- (In reply to comment #0) > Bound field: 1 > Data Field: CurrencyCode > Input required: Yes > List content: SELECT "CurrencyCode" FROM "MyAccounts"."Currency" AS > "Currency" ORDER BY "CurrencyCode" ASC > Type of list content: sql > In 3.5.7 (ubuntu 12.04) this works fine. Hmmm... I don't immediately understand why it used to work. Maybe it would automatically use the first column if "Bound Field" was out of range. > I previously tried to set the > bound column to 0 (ie the 1st field) but that always gets reset to 1 by Base. Does 4.1 still reset to 1? It does not for me. Set it to 0, IMHO it will work. If not, reopen. In 3.5/3.6, set it to empty instead of zero. This should work (in all versions, also in 4.1). > Trying to emulate this with an HSQL engine failed, it works as expected, so > I am unable to post a demonstration odb. For problems that don't happen with embedded HSQLDB, you can attach the .odb taht connects to MySQL *and* a dump of the MySQL database. So, I'm closing the bugs under the assumption that my explanations above help. If they don't feel free to reopen. -- 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
