mfratto
Posts: 34
|
| Posted: 08/28/2005, 6:31 PM |
|
I can't find the answer to this question. I want to add a label to a page that displays the number of rows in a table. I can get the number with "SELECT count(*) FROM table", but I can't figure out how to get that into the lable. When I select label properties, I can't select connection properties.
Any ideas?
Thx.
|
 |
 |
DonB
|
| Posted: 08/28/2005, 8:05 PM |
|
I would guess that you are using a Grid control as the 'table'. Therefore,
the thing to do is create the grid and specify the "Display total number of
records" option.
For an existing grid, just add a Label control and add the "Retrieve number
of records" action to it.
--
DonB
http://www.gotodon.com/ccbth
"mfratto" <mfratto@forum.codecharge> wrote in message
news:543126577ea8d0@news.codecharge.com...
> I can't find the answer to this question. I want to add a label to a page
that
> displays the number of rows in a table. I can get the number with "SELECT
> count(*) FROM table", but I can't figure out how to get that into the
lable.
> When I select label properties, I can't select connection properties.
>
> Any ideas?
>
> Thx.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
mfratto
Posts: 34
|
| Posted: 08/29/2005, 7:32 AM |
|
doh! I musta been way to tired last night. I looked and looked at actions and just didn't see "Retreive number of records." Now that you pointed that out, it's there.
Thanks.
|
|
|
|
|
