Re: DICT question

[Charlie Noah]

Pat, I-Type dict items generally don't perform as efficiently in Jbase as 10-line Pick types. I am basing this on experience with Jbase 3.4.x. Things may be different with 4.x If either will do the job, do a timing test to determine which is faster, especially if it will be used a lot. BTW, in your mvcnt example below, the result will be incorrect if the attribute is null.    COUNT(@RECORD<1>, @VM)  + (@RECORD<1> #  '') or    IF @RECORD<1> # '' THEN COUNT(@RECORD<1>, @VM) + 1 ELSE 0 (or '' if you prefer). will return the correct result. It's a pity DCOUNT() doesn't work, although, again, I'm referring to 3.4.x. Also, in your example, you are using 1 as an attribute reference first, and as a literal second. Depending on your emulation, it will either be one or the other. Regards, Charlie Noah Inland Truck Parts Company pat wrote, On 05/05/2009 05:16 PM: Why restrict yourself to 10 line DICTionary items ? Try the additional features provided by I types DICT file mv2_of_Attr1 Last_mv_of_Attr1 mvcnt mv2_of_Attr1 001 I 002 @RECORD<1,2> 003 004 2nd Value in Attribute 1 005 10L Last_mv_of_Attr1 001 I 002 FIELD(1,@VM,mvcnt) 003 004 Last value in Attribute 1 005 10L mvcnt 001 I 002 COUNT(1,@VM)+1 003 004 Number of values in Attribute 1 005 5R LIST file mv2_of_Attr1 Last_mv_of_Attr1 should give you : 'dave' and 'chris' respectively, based on your data below, Pat. On 5 May, 11:13, inavran <inav...@gmail.com> wrote: Hi, I was wondering if anyone knew the correct syntax for extracting the 'last multi-value' from a field using a 10 line dictionary items eg record (3 attributes with 4 multi-values on each line) 001:john]dave]simon]chris 002:blue]red]yellow]green 003:30]25]42]50 i would want to extract just "chris" from attribute 1. (being the last MV) also, i would be curious how to extract a specific other multi value as well (eg "dave" (MV 2) at present i am doing this using a subroutine CALL within the DICT, which is very slow (as you would expect), so i am keen to get a better solution in place. I am using jBASE 3.4.x on Windows 2003 Many thanks in advance. 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 -~----------~----~----~----~------~----~------~--~---