Joyce, Word of caution... You should be aware that changing the existing dictionary itemss could have an effect on the way other parts of your application work if they are using those same items. If you created new ones then you shouldn't have any problems.
Dick On Fri, Jan 10, 2020 at 7:58 AM Joyce White <joycewhite...@gmail.com> wrote: > Wow, thank you so much! You are absolutely correct, both of my dictionary > definitions were Left-justified. I changed them to Right-justified and now > they are treated numerically! Yay! Thanks, all! You're lifesavers! > > On Thursday, January 9, 2020 at 4:24:51 PM UTC-5, Joyce White 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/b89d8d37-5470-4433-b193-1f4e5683a2f8%40googlegroups.com > <https://groups.google.com/d/msgid/jbase/b89d8d37-5470-4433-b193-1f4e5683a2f8%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -- 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/CAAbj8iqM6CksP7VfskE4vH4vVfSuK1d85D9GGFBchMBB5RKAEg%40mail.gmail.com.
