Dick,
Thanks for the warning - I hadn't considered that changing the
justification could have a negative effect. These ARE existing items, but
they are both numeric fields (or meant to be) only and the values are not
used in reporting anywhere, so I think I should be good. Is that what you
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
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
Hi Joyce:
Check the justification in those Dictionary items. They should both be
Right-justified.
From: jbase@googlegroups.com On Behalf Of Joyce White
Sent: Thursday, January 9, 2020 10:43 AM
To: jBASE
Subject: Query doing string math instead of numeric with LT
I have a jBASE
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 wrote:
> I have a jBASE program that does record selection using a query such as
> this: SELECT X
Are all these dictionaries R-just?
--
--
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
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