FX Rhaps
|
| Posted: 07/31/2002, 12:16 AM |
|
I am trying to get the number of value in a database without success.
I created a HMTL and "form" new label, renamed it, assigned a source type
database column and a control source but it still doesn't work. When i try
my sql command in form properties il return the right value.
Any idea ?
I had look into the code , I found something interesting such as CountSQL,
how can I get this value and make is appear on the page ?
Thanks
Matthieu
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 07/31/2002, 4:19 AM |
|
Create a Grid Form and set SQL in it's "Data Source" property to
select * as cnt from sometable , then select cnt as a source for your label
(Grid consists of 1 Label and 1 resulting row)
--
Alex,
Support Engineer
CodeCharge Team
"FX Rhaps" <fxrhapsody@hotmail.com> wrote in message
news:ai82rp$um2$1@news.codecharge.com...
> I am trying to get the number of value in a database without success.
> I created a HMTL and "form" new label, renamed it, assigned a source type
> database column and a control source but it still doesn't work. When i try
> my sql command in form properties il return the right value.
> Any idea ?
>
> I had look into the code , I found something interesting such as CountSQL,
> how can I get this value and make is appear on the page ?
>
> Thanks
>
> Matthieu
>
>
|
|
|
|
DonB
|
| Posted: 07/31/2002, 4:23 AM |
|
Correction, "SELECT COUNT(*) AS cnt FROM sometable"
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ai8h34$mu6$2@news.codecharge.com...
> Create a Grid Form and set SQL in it's "Data Source" property to
> select * as cnt from sometable , then select cnt as a source for your
label
> (Grid consists of 1 Label and 1 resulting row)
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
>
> "FX Rhaps" <fxrhapsody@hotmail.com> wrote in message
>news:ai82rp$um2$1@news.codecharge.com...
> > I am trying to get the number of value in a database without success.
> > I created a HMTL and "form" new label, renamed it, assigned a source
type
> > database column and a control source but it still doesn't work. When i
try
> > my sql command in form properties il return the right value.
> > Any idea ?
> >
> > I had look into the code , I found something interesting such as
CountSQL,
> > how can I get this value and make is appear on the page ?
> >
> > Thanks
> >
> > Matthieu
> >
> >
>
>
|
|
|
|
FX Rhaps
|
| Posted: 08/01/2002, 12:52 AM |
|
thank you for the help
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:ai8hbj$nbf$1@news.codecharge.com...
> Correction, "SELECT COUNT(*) AS cnt FROM sometable"
>
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:ai8h34$mu6$2@news.codecharge.com...
> > Create a Grid Form and set SQL in it's "Data Source" property to
> > select * as cnt from sometable , then select cnt as a source for your
> label
> > (Grid consists of 1 Label and 1 resulting row)
> >
> > --
> >
> > Alex,
> > Support Engineer
> > CodeCharge Team
> >
> >
> > "FX Rhaps" <fxrhapsody@hotmail.com> wrote in message
> >news:ai82rp$um2$1@news.codecharge.com...
> > > I am trying to get the number of value in a database without success.
> > > I created a HMTL and "form" new label, renamed it, assigned a source
> type
> > > database column and a control source but it still doesn't work. When i
> try
> > > my sql command in form properties il return the right value.
> > > Any idea ?
> > >
> > > I had look into the code , I found something interesting such as
> CountSQL,
> > > how can I get this value and make is appear on the page ?
> > >
> > > Thanks
> > >
> > > Matthieu
> > >
> > >
> >
> >
>
>
|
|
|
|
|
