Re: [libreoffice-users] Re: BASE: bug in table designer

Hi :)
I seem to be given credit for doing a thorough investigation in the quoting.  
Obviously i'm not unhappy with that! lol.  The right person was thanked at the 
time but i can't remember who that was.  Several good names spring to mind.
Regards from
Tom :)



----- Original Message ----
> From: Alexander Thurgood <alex.thurgood@gmail.com>
> To: users@global.libreoffice.org
> Sent: Sat, 25 June, 2011 23:17:17
> Subject: [libreoffice-users] Re: BASE: bug in table designer
>
> Le 24/06/11 21:37, Tom Cloyd a écrit :
>
> Hi Tom,
>
> > Thanks for  this thorough investigation of the behavior I described. I'm
> > glad it was  replicated. I don't think this problem is (for me anyway)
> > much of an  impediment, but I HAVE noticed other problems with default
> > values. To  wit: default values set up in the table designer, do not
> > appear in forms  when a new record is created and the table field is
> > linked to list box.  The list box display remains blank. This happens if
> > the default value is  in the table, OR if it's set in the list box
> > properties. Neither has any  effect in the form, not even when the
> > table/view browser (press F4 to  get this) is active.
>
> Known behaviour, and this is actually currently by  design (well it was
> designed by the people at Oracle). The table/field  creation
> functionality does not transmit default values to the  underlying
> database, you are supposed to use a corresponding form for this  and
> define the default there rather than at the database level. This  was
> done because it was felt it was too difficult (i.e. developer  time
> intensive) for OOo to be able to manage all of the possible  driver
> return handling for all of the various possible database connections  out
> there. However, it does appear that even the form based default  setting
> of values does not work as intended, i.e. the values are not  necessarily
> passed from the form to the underlying db...File a bug, if you  like, but
> I'm pretty sure one has been filed  already.
>
>
> Alex
>
>
> -- 
> Unsubscribe instructions: E-mail to  users+help@global.libreoffice.org
> In  case of problems unsubscribing, write to postmaster@documentfoundation.org
> 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

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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