Re: [libreoffice-users] Re: Where is Base?

Hello again,
As was mentioned in a reply to one of my remarks: Yes, there are a 
number of things missing in the
LO-Front end to databases: Just ONE little thing eg.: When selecting 
tuples using the standard filter,
the selection criteria (max 3 in number) are too restricted.
Like -- eg. if I want to select tuples, where ((fielda = x or fielda = 
y) and fieldb = z) I cannot specify this
(no parenthesis capability!). This kind of filter is naturally possible 
when accessing MySQL through
phpMyAdmin.
But then, it is not a big issue to quickly create a view using native 
SQL. So, while I would like to have
this capability, it doesn't really prevent me from using LO-Base.
On the other hand, trying to build a REAL application system using 
LO-Base and (eg.) Basic Macros and
Forms is not really a choice. I suppose that M$-Access isn't fit to 
handle this kind of requirements either.
For this kind of system I am looking at frameworks such as Symfony2 at 
the moment.
Keep up the good work!
Heinrich


Ian Whitfield schrieb:
> .Ditto!!!
>
> +1
>
> It has cemented the decision I took last year to move to Base+MySQL - 
> which works very well indeed!!
>
> IanW
> Pretoria RSA
>
> On 03/05/2015 04:08 PM, HBarr wrote:
> > Just want to say this thread has been so helpful and enlightening, I 
> > have
> > learned a lot about base, mysql and databases.
> >
> > Tom, thanks for all your input!
> >
> > Howard
> > On 5 Mar 2015 21:29, "Tom Davies" <tomcecf@gmail.com> wrote:
> >
> > > Hi :)
> > > I have been told, off-list, that i am quite wrong about what i have 
> > > been
> > > saying about Base.
> > >
> > > I'm not clear exactly which bits of what i have said are wrong.  
> > > Almost all
> > > of what i said was things i had picked-up from experts on this 
> > > mailing list
> > > or discussions elsewhere, rather than from my own direct experience or
> > > knowledge of the issues.  It would be nice to know where i am wrong 
> > > to help
> > > me be less wrong in the future!
> > >
> > > Also it would be good for such corrections to be in this thread if 
> > > possible
> > > because it has been a really good thread with a lot of good feedback 
> > > about
> > > different people's knowledge and experience.
> > >
> > > Finally if i have given people a wrong impression about Base then it 
> > > would
> > > be nice to be able to fix that.
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > > On 4 March 2015 at 16:40, Tom Davies <tomcecf@gmail.com> wrote:
> > >
> > > > Hi :)
> > > > Yeh, in attempting to clarify i did add an extra confusion! Sorry!  
> > > > The
> > > > HsqlDb version 1.8 is only a problem when using the internal 
> > > > version in
> > > > Base.  However Base doesn't give you much choice about what to use 
> > > > as the
> > > > internal back-end.  Just the heavily tweaked and broken version of 
> > > > 1.8.
> > > > Regards from
> > > > Tom :)
> > > >
> > > >
> > > > On 4 March 2015 at 10:58, Andreas Säger <villeroy@t-online.de> wrote:
> > > >
> > > > > Am 04.03.2015 um 11:03 schrieb Tom Davies:
> > > > > > Hi :)
> > > > > > I think Noel (& Marion)'s good experience of H2 being sooo much 
> > > > > > better
> > > > > than
> > > > > > Base is purely down to them moving away from the internal 
> > > > > > back-end in
> > > > > > Base.  The version of HsqlDb mentioned by Noel is the 1.8 which
> > > Andreas
> > > > > > identified as being the version used as the internal back-end in 
> > > > > > Base.
> > > > > The problem is _not_ a particular version of a particular 
> > > > > database. If
> > > > > HSQL 1.8 works for you, even that version works as a rock stable, 
> > > > > fast
> > > > > and reliable backend to your Base document.
> > > > >
> > > > > Heinrich demanded an _interface_ to handle the big irons. He was not
> > > > > talking about a particular version of some particular big iron. He 
> > > > > did
> > > > > not tell us what is wrong with the current interface. From the view
> > > > > point of database developers, there are several missing features. 
> > > > > From
> > > > > the view point of someone who wants to build a serial letter from his
> > > > > spreadsheet, Base is the big and dark mystery to be avoided 
> > > > > entirely and
> > > > > the serial letter wizard does not mention that one of its products 
> > > > > is a
> > > > > Base document together with the serial letter.
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe e-mail to: users+unsubscribe@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
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@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


--
To unsubscribe e-mail to: users+unsubscribe@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