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:* [email protected] [mailto:[email protected]] *On Behalf Of *Charlie Noah *Sent:* Tuesday, July 19, 2011 2:36 PM *To:* [email protected] *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 <[email protected]> <[email protected]> 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 [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
