*jBASE 5.2 appears to work identically to jBASE 3.4.* * * *On jBASE 3.4:* * * *jsh ~ -->LIST IM QOH* * * *IM............ QOH* * * *1 * *2 0 * * * *jsh ~ -->SELECT IM WITH QOH NE "0"* * * * 1 Records selected * * * *>* * * *Dan Klein*
On Mon, Feb 4, 2013 at 9:50 AM, Darrin <[email protected]> wrote: > 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] > 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. > > > -- -- 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.
