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 [email protected]<mailto:[email protected]> on behalf of your company?
Thanks, Mike From: [email protected] <[email protected]> On Behalf Of Joyce White Sent: 10 January 2020 20:06 To: jBASE <[email protected]> Subject: 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 quotes around the "1", it brings back all that are true. 2) If I DON'T put quotes around the 1, it brings back only the ones with a difference of 1....but it also brings back the ones where both are 0. 3) If I use 2 at the end, I get the following: Balance. Quantity 1 4 1 2 0 0 4) It doesn't seem to work with any other numbers at the end. Brings back nothing. Can you explain exactly HOW it is evaluating? I'm just curious. Thanks! Joyce On Thursday, January 9, 2020 at 4:38:11 PM UTC-5, pfalson wrote: EVAL “expression” [as alias] eg. LIST myfile EVAL "@ID[1,3] AS FIRST_THREE -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.google.com%2Fgroup%2FjBASE%3Fhl%3Den&data=02%7C01%7Cmikes%40jbase.com%7C5117ed07eff547bff1b308d79614243a%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637142885584359306&sdata=9UASynf4JAcjRwlB6aSs0YdRP3AUqYGmGIdADyGJKJc%3D&reserved=0> --- 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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/9bf7c3e0-6358-4be0-afb3-cf33811004be%40googlegroups.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fjbase%2F9bf7c3e0-6358-4be0-afb3-cf33811004be%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=02%7C01%7Cmikes%40jbase.com%7C5117ed07eff547bff1b308d79614243a%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637142885584369302&sdata=ZGTnYBY%2BSr2xbkvK0I6s0O7QIrEAyFvz8%2B7Oj97g%2F88%3D&reserved=0>. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/MW2PR18MB2122835B9292A8CF8F6AEFB2B3380%40MW2PR18MB2122.namprd18.prod.outlook.com.
