Re: [libreoffice-users] Re: Multiple select field in Base forms

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: users+help@global.libreoffice.org
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