Re: BOM Problem

On 13-Apr-09, at 2:08 PM, Dudás Zsolt wrote:

> Dear Nathan,
>
> Some versions of PHP handle badly the order of math relationship.
> If effective_to_date is null and you try to compare this way,
> first is 'OR' relation then 'NOW()<='.
> That's why the get_bill_of_material_list function retuns empty.

Which versions of PHP have this issue?

That's SQL, not PHP.
http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html

You did not address my concern:
>
>> In addition, in the case where a future BOM for a new product is to
>> take effect in one week, with no effective_to_date, would it not show
>> as a current BOM as well as future?
>

In example form, given the following BOMs:
#1
Effective from: 2009-01-01
Effective to: null

#2
Effective from: 2009-06-01
Effective to: null

#3
Effective from: 2009-01-01
Effective to: 2009-06-01

and
NOW() = 2009-04-13, the expected result is #1, #3
NOW() = 2009-01-01, the expected result is #1, #3
NOW() = 2009-06-10, the expected result is #1, #2
assuming all other parameters are equal.

> ps. You can see the hungarian transilation of your system in  
> attached file.
> Not final, but it's good enoungth. Use it,if you want.

Thanks, I'll wait until you get it done.  When you do get it ready,  
please send it as a zip.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers