You can do it using the CONV jQL extension LIST MYFILE *A0 CONV ‘A;S( 42 # “” )’
In other words, just put the correlative from 8 as the CONV with single quotes around it. Dan Ell From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Klein Sent: Friday, December 19, 2014 3:43 PM To: [email protected] Subject: Re: jBase on Linux - SELECT How can you do this without creating a DICT item, unless you intend to do it with a BASIC program? Dan On Fri, Dec 19, 2014 at 3:16 PM, Daniel Klein <[email protected]<mailto:[email protected]>> wrote: Assuming you are looking for the A-type (10-line) dictionary format and the data is in attribute 42 : ID: ITEMS.ORDERD 0001 A 0002 0 0003 0004 0005 0006 0007 MD0, 0008 A;S( 42 # "" ) 0009 R 0010 10 Dan On Fri, Dec 19, 2014 at 1:52 PM, wsw <[email protected]<mailto:[email protected]>> wrote: Without using an I-TYPE or creating a DICT item is there a way to count the number of items in a particular field that actually have a value. Example; 1]2]3]]]]]10]11]25 I would like the list to display like MYFILE.......... ITEMS.ORDERED 293569 6 1 Records Listed Thanks in advance, WW -- -- 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 --- 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]>. For more options, visit https://groups.google.com/d/optout. -- -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- -- 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]. For more options, visit https://groups.google.com/d/optout.
