Might be better SELECT IM WITHOUT QOH = "0" "" which is actually what you stated you want.
Dan Ell From: [email protected] [mailto:[email protected]] On Behalf Of Darrin Sent: Monday, February 04, 2013 9:51 AM To: [email protected] Subject: Re: jBASE migration 3.4 to 5.2 - How difficult? Ran into another one this morning... JQL now appears to be doing string comparison rather than value comparison when dealing with the value of zero. For example, to process every record in IM with a non-zero quantity on hand. SELECT IM WITH QOH NE "0" Previously this excluded records with a QOH of "". Now it does not. Off the top of my head, the easiest fix is the following: SELECT IM WITH QOH > "0" Time to get friendly with regular expressions and see how many occurrences of this we have in our code base.... -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
