Dictionaries that are R justified will be assumed mathematical; dictionaries that are L justified will be treated as strings.
Hope this helps! Josh C On Thu, Jan 9, 2020 at 3:24 PM Joyce White <joycewhite...@gmail.com> wrote: > I have a jBASE program that does record selection using a query such as > this: SELECT X WITH BALANCE LT QUANTITY > BALANCE and QUANTITY are data dictionary-defined fields for fields 1 & 2. > My issue is this - the query is doing string math instead of number math. > For instance, 2 LT 9 evaluates as true, 2 LT 10 does NOT evaluate as true. > > How can I define my fields OR change the query so my query selection > compares these values numerically instead of as strings? > > Thanks! > Joyce > > -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to jBASE@googlegroups.com > To unsubscribe, send email to jbase-unsubscr...@googlegroups.com > 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 jbase+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jbase/d5c0e42d-28a9-4774-af4d-7ddbbf5dd2fd%40googlegroups.com > <https://groups.google.com/d/msgid/jbase/d5c0e42d-28a9-4774-af4d-7ddbbf5dd2fd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Joshua Camacho wyck...@gmail.com (773) 988-0846 -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAAEHHziEG8oc1A6HxsBRCQbKjkoQa4QQFaY7%3DMH9ZzKs%3D-D%3DXQ%40mail.gmail.com.
