RE: jBASE EVAL Help?

Joyce, > Can you explain exactly HOW it is evaluating? I'm just curious. If you require in-depth feedback on this, can you please submit a ticket to dev...@jbase.com on behalf of your company? Thanks, Mike From: jbase@googlegroups.com On Behalf Of Joyce White Sent: 10

Re: jBASE EVAL Help?

Add an AS before your = > SELECT X WITH EVAL "BALANCE LT QUANTITY" AS balLTqty = "1" > Sent from my iPhone > On Jan 10, 2020, at 1:29 PM, Joyce White wrote: > >  > Thanks, pfalson! My use of it is more in a query, like below: > SELECT X WITH EVAL "BALANCE LT QUANTITY" = "1" > SELECT X WITH

Re: jBASE EVAL Help?

Thanks, pfalson! My use of it is more in a query, like below: SELECT X WITH EVAL "BALANCE LT QUANTITY" = "1" SELECT X WITH EVAL "BALANCE LT QUANTITY" = 1 It seems like it's just evaluating for true/false, and expecting 1/0 as the response. But I ran into a few curious things. 1) If I put

Re: Query doing string math instead of numeric with LT

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

Re: Query doing string math instead of numeric with LT

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

Re: Query doing string math instead of numeric with LT

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

RE: Query doing string math instead of numeric with LT

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

Re: Query doing string math instead of numeric with LT

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