Looping Through a DataView

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.

--- 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
>
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.
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
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
>
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
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
>
Bob,

If I am understanding you correctly, you are missing the count identifier. Try something like this:

For i As Integer = 0 to edvQL.dataView.Count-1
Dim edvLineX As String = edvQL.dataView(i)("QuoteLine")
MsgBox(edvLineX)
Next

Ross


--- In vantage@yahoogroups.com, "bobschnable" <bschnable@...> wrote:
>
> 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
> >
>
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