Re: [libreoffice-users] Re: Base/SQL help

On Thu, Jan 5, 2012 at 1:08 PM, Jeff Sadowski <jeff.sadowski@gmail.com> wrote:
> On Thu, Jan 5, 2012 at 11:59 AM, Alexander Thurgood
> <alex.thurgood@gmail.com> wrote:
> > Le 05/01/12 19:26, Jeff Sadowski a écrit :
> >
> > Hi Jeff,
> >
> > > Thank you for mentioning datediff
> > > "SELECT * FROM `modifiedprintusage` where
> > > DATEDIFF(CURRENT_DATE,`date`)<3 ORDER BY `ip` DESC;"
> > > works great from the commandline mysql but libreoffice is rejecting it.
> >
> > It should work with the SQL parser turned off, but this means that you
> > can't use the graphical query designer, you can only work in SQL mode.
> How do you turn it off?
> I don't see the option.
Found it
Edit->"Run SQL command directly"
did the trick.
It would be nice if the design view worked a bit better but I can live
without it.
> > Alex
> >
> >
> > --
> > 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

-- 
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