ODBiC Discussion Board

RE: Probelm Idenified, Gordon Hsu, 08-13-2006

You are using mName1 in both EACHROW loops?

by Roger Harris, August 17, 2006 08:07

I may be misunderstanding what you mean, but it seems you may be misunderstanding how EACHMULTI works. In the code you posted, you have mName1 in both of your EACHROW loops. If the first loop returns 3 rows and the second loop returns 3 rows, then you have a total of 6 instances of nName1. The first pass of the EACHMULTI mName1, mName5, mName6 loop will take the first instance of mName1 (which came from the first EACHROW loop), and the first instances of mName5 and mName6 (which came from the second EACHROW loop. After the third loop, the EACHMULTI will continue taking the 4th, 5th and 6th instances of mName1, but mName5 and mName6 won't have those instances, so they will be set to empty for the 4th, 5th and 6th EACHMULTI pass.


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.