Jim
Good thoughts... Can you recommend a suite of "unix" tools that I can
use under Windows for this ?
I'm a big proponent of using non-jBase tools with jBASE (which I do) -
I was hoping that I was missing something in my knowledge of jQL which
might do the exclusion for me (I note another similar thread today on
the same subject).
Thanks
Simon
On 27/09/2010 21:45, Jim Idle wrote:
1) Execute it in a bash script and grep --v "0\.00"
2) Or SORT it with the total displayed in the first column and pipe
the output to sort -rn
3) Or SORT it and [ipe the output to awk
Etc etc.
Don't limit yourselves to the MV only way of doing things as that was
the whole point of jBASE.
Jim
*From:* [email protected] [mailto:[email protected]] *On
Behalf Of *Daniel Klein
*Sent:* Sunday, September 26, 2010 6:12 AM
*To:* [email protected]
*Subject:* Re: jdbc
There's no iphone app that will do that? ;-)
Seriously, you would spool the report to a file and then post-process
the file.
Dan
On Sun, Sep 26, 2010 at 7:00 AM, Simon Verona <[email protected]
<mailto:[email protected]>> wrote:
Hi all
This may or may not be a stupid question.
I have a transaction file, with many thousands of entries in, which
should total zero both on a daily basis (there is a date field in the
file) and overall.
If I have a problem, then a check is to find which dates do not come
back to zero...
So, I execute a jQL query like :
SORT TRANSACTIONS BY DATE BREAK-ON DATE "'VL'" TOTAL 2 (D)
Which produces a list like :
02/07/2010 0.00
01/07/2010 0.00
30/06/2010 0.00
29/06/2010 -585.31
28/06/2010 0.00
27/06/2010 0.00
etc etc
All I want to see though is the dates that don't come to zero....
Can this be done using jQL?
Thanks
Simon
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions
specific to Globus/T24
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
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions
specific to Globus/T24
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
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions
specific to Globus/T24
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
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
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
