Thanks a lot guys. Both methods work great. I appreciate all the help.
I can't believe I didn't think to apply the count within the variable assignment.
Thanks again.
I can't believe I didn't think to apply the count within the variable assignment.
Thanks again.
--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> OK, I wasn't looking at this close enough. The data is pulled into the
> "QuoteLine" DataRow so you need to display the DataRow value. You may want
> to change the QuoteLine DataRow to qlDR (Quote Line DataRow) so there is
> less confusion in the code
>
>
> Dim edvLinX as String
>
> For each qlDR as DataRow in edvQL.dataview.Table.Rows
> edvLinX = qlDR ("QuoteLine")
> MessageBox.Show(edvLinX)
> Next
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> bobschnable
> Sent: Tuesday, August 24, 2010 3:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Looping Through a DataView
>
> Thanks Scott,
>
> I still seem to be having the same issue. I declared the variable outside of
> the loop, and the data is still repeating.
>
> I appreciate all of your help on this.
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@> wrote:
> >
> > Keep the variable declaration outside of the loop.
> >
> >
> > Dim edvLinX as String
> >
> > For each QuoteLine as DataRow in edvQL.dataview.Table.Rows
> > edvLinX = edvQL.dataView(edvQL.row)("QuoteLine")
> > MsgBox(edvLinX)
> > Next
> >
> >
> > Scott
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of bobschnable
> > Sent: Tuesday, August 24, 2010 2:31 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Looping Through a DataView
> >
> > Thanks for the reply Scott. The loop works great, but the data is
> > still giving me the same issue. I used:
> >
> > For each QuoteLine as DataRow in edvQL.dataview.Table.Rows Dim
> > edvLineX As String = edvQL.dataView(edvQL.row)("QuoteLine")
> > MsgBox(edvLineX)
> > Next
> >
> > And the MsgBox still displays the same line num twice. If I am looking
> > at Line 1 before I click the button that executes the code, I get line
> > 1 twice in the MsgBox, and likewise for line 2. I assume this has to
> > do with the fact that I'm using an EpiDataView, but I can't figure out
> > what else to use to get the data I need.
> >
> > Thanks
> >
> >
> > --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@> wrote:
> > >
> > > Try this
> > >
> > > For each QUOTELINE as DataRow in edvQuoteDtl.dataview.Table.Rows
> > > DO YOUR ASSIGMENTS HERE
> > > Next
> > >
> > > Scott
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of bobschnable
> > > Sent: Tuesday, August 24, 2010 1:48 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Looping Through a DataView
> > >
> > > Hi Group,
> > >
> > > I am trying to loop through a dataview in a customization I have to
> > > get the needed information. Currently, the customization populates
> > > data in a form outside of Vantage. It is operating on the
> > > QuoteEntry, and works great. I am now attempting to account for
> > > multiple lines per quote, and I seem to be struggling.
> > >
> > > The best I have is the following:
> > >
> > > For i As Integer = 0 to edvQL.dataView.Count-1 Dim edvLineX As
> > > String = edvQL.dataView(edvQL.Row)("QuoteLine")
> > > MsgBox(edvLineX)
> > > Next
> > >
> > > Which fires the MsgBox the appropriate number of times per number of
> > > lines, but the content of the box remains the same. I need to start
> > > at line 1, populate a set of data, and move on to line 2 to pull
> > > from the same fields and populate another matching form. I've tried
> > > all sorts of combination's of code I've found on here, so I appreciate
> any help!
> > > Thanks in advance.
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must have already linked your email address to a yahoo id to enable
> access.
> > > )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> > )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>