Re: DCOUNT in DICT, Which Correlative?

[Charlie Noah]

Hi Jim, It's been a while! For the most part you are correct. However, it could be useful to count csv values within an attribute (we're dealing with csv more and more), and it obviously can be useful to know how many multivalues there are. I don't know how many times I've run across definitions that don't take a null attribute into account. Besides, most of us work with systems we've inherited, and which may not have been real well designed in the first place. Many were built by users who found Multivalue based environments so easy to build things in that they considered them developers, even though they were not at all qualified. We still have to work with them, though, and I don't know about you, but I'm getting too old and tired to redesign every system I run across. :-P Besides, the OP asked for a technical solution to a specific need, not describing the overall scenario, and that's what he got. It's a shame Jbase didn't incorporate DCOUNT into JQL (perhaps by now it has). Best, Charlie On 07-19-2011 6:02 PM, Jim Idle wrote: Actually, woah mule, woah mule!!!   1.       The fact that it is awkward to do should be telling you something. 2.       It should be telling you that your data model is completely screwed up. 3.       In the MV model, the separators are AM, VM and SVM. 4.       If you have comma separated values in an attribute mark, then it means you have utterly disregarded the MV data model 5.       You should have multivalues. 6.       You should correlate them if order is important. 7.       Now you find you must count the commas because you are ignoring the data model and have set out down the path to a terribly organized database. 8.       However, don’t feel so bad, as you are merely joining the ranks of just about everyone else.   Jim   From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of Charlie Noah Sent: Tuesday, July 19, 2011 2:36 PM To: jbase@googlegroups.com Subject: Re: DCOUNT in DICT, Which Correlative?   002 COUNT(@RECORD<1>, ',') 002 COUNT(@RECORD<3>, @VM) counts the number of commas and value marks, respectively 002 IF @RECORD<1> # '' THEN COUNT(@RECORD<1>, ',') + '1' ELSE '0' 002 IF @RECORD<3> # '' THEN COUNT(@RECORD<3>, @VM) + '1' ELSE '0' counts the number of comma and value mark delimited values (even if the values are null), respectively Charlie Noah On 07-19-2011 3:55 PM, pat wrote: Try :     DICT file comma_count   001 I 002 COUNT(f1,',') 003 004 Commas in Attr1 005 10R   DICT file f1   001 D 002 1 003 004 Attr1 005 10L   DICT file vm_count   001 I 002 COUNT(f3,',') 003 004 VM's in Attr3 005 10R   DICT file f3   001 D 002 1 003 004 Attr3 005 10L   On Jul 19, 3:10 pm, inavran <inav...@gmail.com> wrote: Hi,   Does anyone know the equivalent correlative or command for what would be DCOUNT()  in DATABASIC, in a DICT.   eg.   1) I would like to count how many commas "," there are in attribute 1 2) I would like to count how many @VMs there are in attribute 3   Im assuming its the same command for both of the above.   I was playing with Corr type A,  NV, but that lists a rolling count of the value markers and explodes them out.   Any suggestions would be helpful.   many thanks   Ian   -- 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 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 -- 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 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 -- 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 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