Re: [WebERP-developers] Shall we change the SQL end date to 9999-12-31?

[Pak R. <pak...@gm...>]

Hi Exson:

I brought it up long time ago as it would help to simplify all queries
regarding prices, as we do not need to add the OR enddate = '0000-00-00'
condition everywhere to detect the current active price. That was my main
goal then, as keeping it as 0000-00-00 was messing with the Joomla!
extension I used back then.

Really can't remember the reason why it was decided to keep it as is
(probably a tech reason beyond my understanding), so I can't help much.

As usual, if you decide to go ahead with this change, will be happy to test
i!

Regards,
Ricard


2014-04-06 15:55 GMT+08:00 Tim Schofield <tim...@gm...>:

> Hi Exson,
>
> I remember Ricard brought this up a few years ago but Phil wanted to
> stay using the 0000-00-00 dates at the time.
>
> Thanks
> Tim
>
> On 6 April 2014 04:34, ExsonQu <hex...@gm...> wrote:
> > *Dear all,*
> >
> >          Thank you very much for your great work to webERP community.
> >
> >          I've detected a problem in Prices.php when it runs in mysql
> strict
> > mode. It will be error for $SQLEndDate='0000-00-00'.
> >
> >         Shall we change this to '9999-12-31' to coincide with mysql's
> > definition. Otherwise, users use this strict mode we have to face the
> > problem when they do not set the effective end date.
> >
> >         Any comments are highly appreciated!
> >
> >         Thanks and best regards!
> >
> >         Exson
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Shall-we-change-the-SQL-end-date-to-9999-12-31-tp4657341.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>