Number of rows in a table

Yahoo Archive
1
Then why don't you pull the table contents into a user grid and count the rows there. It doesn't have to be visible.


Lisa Kelepolo
Data Process Improvement, Database, & Reporting
Electromech Technologies
316-941-0401
please visit our website: www.electromech.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of phoenix
Sent: Saturday, November 27, 2010 2:15 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Number of rows in a table

Again,
it gives you as many rows, as you have in dataview. So if in data view there will only one row it gives you one row as result. It depends what is currently in dataview.

regards

Dnia Tue, 23 Nov 2010 23:12:20 -0000
"lkelepolo" <lkelepolo@...> napisał(a):

> Try this:
>
> Private WithEvents edvUD02 As EpiDataView
> edvUD02 = CType(oTrans.EpiDataViews("UD02"), EpiDataView dim edvCount
> as int32 = edvUD02.dataview.count
>
>
> --- In vantage@yahoogroups.com, "g_stuff7" <gkinlocke@...> wrote:
> >
> > Good Day Everyone,
> >
> > I am working on a customization in which I need the TOTAL number of
> > rows for a particular UD table, however I am only getting the number
> > of rows in that particular view for the table, which is usually 0. I
> > am using VB.Net and below is the piece of code that I am trying to
> > use to get the row count, can someone please point me in the right
> > direction?
> >
> > rowCnt = _ud06Adapter.UD06Data.UD06.Rows.Count
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Gezeta Kinlocke, BEng, EIT, PMP
> >
>
>


------------------------------------

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
2
Good Day Everyone,

I am working on a customization in which I need the TOTAL number of rows for a particular UD table, however I am only getting the number of rows in that particular view for the table, which is usually 0. I am using VB.Net and below is the piece of code that I am trying to use to get the row count, can someone please point me in the right direction?

rowCnt = _ud06Adapter.UD06Data.UD06.Rows.Count



Thank you,



Gezeta Kinlocke, BEng, EIT, PMP
3
Try this:

Private WithEvents edvUD02 As EpiDataView
edvUD02 = CType(oTrans.EpiDataViews("UD02"), EpiDataView
dim edvCount as int32 = edvUD02.dataview.count


--- In vantage@yahoogroups.com, "g_stuff7" <gkinlocke@...> wrote:
>
> Good Day Everyone,
>
> I am working on a customization in which I need the TOTAL number of rows for a particular UD table, however I am only getting the number of rows in that particular view for the table, which is usually 0. I am using VB.Net and below is the piece of code that I am trying to use to get the row count, can someone please point me in the right direction?
>
> rowCnt = _ud06Adapter.UD06Data.UD06.Rows.Count
>
>
>
> Thank you,
>
>
>
> Gezeta Kinlocke, BEng, EIT, PMP
>
4
It gives you a number equal to number of rows in ud06adapter. If
earlier the method GetRows or GetList for this adapter was invoked
(which populated adapter with data) then you will receive a number of
rows in table.
So answer to your question is: it depends what data you have currently
in adapter.

regards

Dnia Tue, 23 Nov 2010 22:39:13 -0000
"g_stuff7" <gkinlocke@...> napisał(a):

> Good Day Everyone,
>
> I am working on a customization in which I need the TOTAL number of
> rows for a particular UD table, however I am only getting the number
> of rows in that particular view for the table, which is usually 0. I
> am using VB.Net and below is the piece of code that I am trying to
> use to get the row count, can someone please point me in the right
> direction?
>
> rowCnt = _ud06Adapter.UD06Data.UD06.Rows.Count
>
>
>
> Thank you,
>
>
>
> Gezeta Kinlocke, BEng, EIT, PMP
>
5
Again,
it gives you as many rows, as you have in dataview. So if
in data view there will only one row it gives you one row as result. It
depends what is currently in dataview.

regards

Dnia Tue, 23 Nov 2010 23:12:20 -0000
"lkelepolo" <lkelepolo@...> napisał(a):

> Try this:
>
> Private WithEvents edvUD02 As EpiDataView
> edvUD02 = CType(oTrans.EpiDataViews("UD02"), EpiDataView
> dim edvCount as int32 = edvUD02.dataview.count
>
>
> --- In vantage@yahoogroups.com, "g_stuff7" <gkinlocke@...> wrote:
> >
> > Good Day Everyone,
> >
> > I am working on a customization in which I need the TOTAL number of
> > rows for a particular UD table, however I am only getting the
> > number of rows in that particular view for the table, which is
> > usually 0. I am using VB.Net and below is the piece of code that I
> > am trying to use to get the row count, can someone please point me
> > in the right direction?
> >
> > rowCnt = _ud06Adapter.UD06Data.UD06.Rows.Count
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Gezeta Kinlocke, BEng, EIT, PMP
> >
>
>