I have an item that has 3 multi-valued attributes that are each approximately 300 transactions long. These 3 attributes are linked -- for example, the third transaction in attribute 46 is linked with the third transaction in attribute 47.Is there an easy way to prune the first 200 transactions from the 3 attributes?
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
What about:
X(1)=TRANS<1>
X(2)=TRANS<2>
X(3)=TRANS< 3>
NEWT=""
FOR T=1 TO 3
FOR Q=201 TO MAXTRANS
NEWT<T,Q>=X(T)<1,Q>
NEXT Q
NEXT T
TRANS=NEWT
Forgot
MAXTRANS=DCOUNT(TRANS<1>,CHAR(253))
One other typo
NEWT<T,Q-200>=X(T)<1,Q>
I guess you could also:
FOR T=1 TO 3
FOR Q=1 TO 200
DEL TRANS<T,Q>
NEXT Q
NEXT T
However, I've had issues sometimes with the dynamic array getting totally screwed up using the DEL
but I believe that to be an issue with running a 32bit UV on a 64bit Linux - it shouldn't be a problem...but it is
yeah...I know 200 to 1 step -1
or
DEL TRANS<T,1> using the 1 to 200
I guess you could also:
Forgot
MAXTRANS=DCOUNT(TRANS<1>,CHAR(253))
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
FOR T=1 TO 3
FOR Q=1 TO 200
DEL TRANS<3-T+1,200-Q+1>
NEXT Q
NEXT T
FOR X = 1 TO 200
DEL REC< 45, 1 >
DEL REC< 46, 1 >
DEL REC< 47, 1 >
NEXT X
That would indeed screw it up. You would need to delete value 1, not value Q.
FOR T=1 TO 3
FOR Q=1 TO 200
DEL TRANS<T,1Q>
NEXT Q
NEXT T
|
I like that....
Forgot
MAXTRANS=DCOUNT(TRANS<1>,CHAR(253))
To unsubscribe, email to: mvdbms+un...@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
--
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
REC<1>[ @VM , 200 , -1 ] = ""
...