On Fri, 2012-01-13 at 12:58 +0100, Alex Thurgood wrote: > Le 13/01/2012 06:15, Marni Wilson a écrit : > > Hi Marni, > > > I am new to LibreOffice, and downloaded it initially for Base. The main > > purpose for my database search is to create a music library, with details > > such as vocal parts, church season, instruments, etc. Some of these would > > be best suited as a multiple select option in the form, but I seem to be > > having difficulty creating that. Am I missing something? This is my third > > attempt to find a database program that will give me this option...is it > > possible in Base? > > > > Try looking here : > > http://www.oooforum.org/forum/viewtopic.phtml?t=21159 > > http://www.oooforum.org/forum/viewtopic.phtml?t=27761 > > http://www.oooforum.org/forum/viewtopic.phtml?t=126402 > > http://www.oooforum.org/forum/viewtopic.phtml?t=37079 > > http://www.factooorpro.net/viewtopic.php?f=9&t=4909 > > http://user.services.openoffice.org/fr/forum/viewtopic.php?f=3&t=29806 > > http://user.services.openoffice.org/fr/forum/viewtopic.php?f=9&t=27622&hilit=s%C3%A9lection+multiple > > > Basically, from what I understand of the above threads, if you want to > bind the multiple values selected to a database field, then this is not > possible with the current multiple selection control property. > > A multiple selection is only available for a free standing form control > list, i.e. one in which the data is presented or displayed in a Writer > form or Calc sheet, but can not be bound to a database field, unless you > store the values individually in a corresponding table (n-m > relationship). Alternatively, it is also apparently possible to do this > using a macro to write the data from the multiple selection into > corresponding fields in a bound table. > > As far as I know, Base does not currently support writing to ENUM or SET > data types, and most likely the control properties do not provide for > that within the current UNO API (although I haven't checked). > > Hi Alex,
The data controls will read/write to those filed types, when the connected database engine supports them - what the built in controls will not do is parse the results for the GUI. IIRC this post on one of the forums that includes a script that does parse a set enum, with example showing how to connect the script to a list control in multi-select mode. http://www.oooforum.org/forum/viewtopic.phtml?t=37079 Haven't looked at that in a long time - it sounds like what the person needs.. I'll try the script and make sure it still works, but can't really see why it wouldn't still. //drew -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
