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
meant by having an effect -that another part of the program might be
expecting them to act like strings? I'll scan through the code and see
where they're used, just to be sure.
Thank you!
Joyce
On Friday, January 10, 2020 at 11:17:39 AM UTC-5, Dick Thiot wrote:
>
> 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 <joycew...@gmail.com
> <javascript:>> 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 jb...@googlegroups.com <javascript:>
>> To unsubscribe, send email to jbase-un...@googlegroups.com <javascript:>
>> 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 jb...@googlegroups.com <javascript:>.
>> 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/8b6705c0-0a52-4362-b55a-ed7151d5347a%40googlegroups.com.
