dbTalk Databases Forums  

Using L Processing Code with MVs

comp.databases.pick comp.databases.pick


Discuss Using L Processing Code with MVs in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ddspell-m3
 
Posts: n/a

Default Using L Processing Code with MVs - 10-03-2006 , 09:53 AM







Is it possible to use the L processing code on a multi-valued field to
get the length of each value?

If so, how?


Thanks,
Danny


Reply With Quote
  #2  
Old   
Mike Wooding
 
Posts: n/a

Default Re: Using L Processing Code with MVs - 10-03-2006 , 12:08 PM






"ddspell-m3" <ddspell (AT) yahoo (DOT) com> wrote

Quote:
Is it possible to use the L processing code on a multi-valued field to
get the length of each value?

If so, how?
Not sure what flavour you're using, but on D3, the following will work in
the attribute 8 of the relevant dictionary:

F{mv#}]L0

Where {mv#} should be replaced with your multi-valued attribute number and
the square bracket is actually a value mark.

HTH

With Kindest Regards

Mike Wooding




Reply With Quote
  #3  
Old   
Tom Phillips
 
Posts: n/a

Default Re: Using L Processing Code with MVs - 10-03-2006 , 06:25 PM



Mike's solution works just fine - and in Universe (using Mike's notation)
this also does the trick (without the value mark):
F;(mv#);(L0) - example: F;5;(L0) where attribute 5 has is the multi-valued
data.
Tom
"Mike Wooding" <mikewooding (AT) email (DOT) com> wrote

Quote:
"ddspell-m3" <ddspell (AT) yahoo (DOT) com> wrote in message
news:1159887195.927312.162910 (AT) e3g2000cwe (DOT) googlegroups.com
Is it possible to use the L processing code on a multi-valued field to
get the length of each value?

If so, how?

Not sure what flavour you're using, but on D3, the following will work in
the attribute 8 of the relevant dictionary:

F{mv#}]L0

Where {mv#} should be replaced with your multi-valued attribute number and
the square bracket is actually a value mark.

HTH

With Kindest Regards

Mike Wooding





Reply With Quote
  #4  
Old   
Scott Ballinger
 
Posts: n/a

Default Re: Using L Processing Code with MVs - 10-03-2006 , 07:25 PM



I think you can just use the "L" correlative by itself- it does not
need to be wrapped in an "F" correlative. And I don't think you need
the zero either, i.e. just put "L" in attribute 8 of a (pick type) dict
item, reference the field you want the length of in attribute 2, and
that's it. Works the same for single or multi-value fields in both D3
and Universe.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

Tom Phillips wrote:
Quote:
Mike's solution works just fine - and in Universe (using Mike's notation)
this also does the trick (without the value mark):
F;(mv#);(L0) - example: F;5;(L0) where attribute 5 has is the multi-valued
data.


Reply With Quote
  #5  
Old   
ddspell-m3
 
Posts: n/a

Default Re: Using L Processing Code with MVs - 10-16-2006 , 06:29 PM




Scott Ballinger wrote:
Quote:
I think you can just use the "L" correlative by itself- it does not
need to be wrapped in an "F" correlative. And I don't think you need
the zero either, i.e. just put "L" in attribute 8 of a (pick type) dict
item, reference the field you want the length of in attribute 2, and
that's it. Works the same for single or multi-value fields in both D3
and Universe.

Yes, this works for me since I'm using D3.

The only odd thing is that I cannot mix a single and multi-valued field
in my LIST statement. You see I have a field named LIS which is a
group identifier and LI.PARTS is a member. I setup the correlative as
LEN.PARTS, then when I do LIST SO LIS LEN.PARTS, I can see the results.
But if I do, LIST SO LIS LI.PARTS LEN.PARTS, the results for LEN.PARTS
are not displayed. I tried LIST SO LEN.PARTS LIS LI.PARTS, but that
didn't work either. In this case, I get the results for LEN.PARTS, but
I don't see LI.PARTS. If I do LIST SO LEN.PARTS, I don't get the
results for LEN.PARTS, so having the group identifier is necessary, but
I can't have both LI.PARTS and LEN.PARTS in the same listing.


Thanks,
Danny



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.