Xavier
|
| Posted: 06/18/2002, 4:10 AM |
|
Hello CC experts,
I've a search and a grid form in the same page.
Grid shows selected records by creation date and company code.
I put a second grid form in. It's just a one-field (label) grid,
and in its SQL form properties I checked "use SQL string" and wrote this:
select count(*) as total_number_of_records from table_name;
In this way I always get the total number of not-null records in database.
I'd like to have the correct number of records selected, but once "use SQL
string" is selected
it's impossible to set some input parameters in Input form properties,
except the variable used for the select count.
Can any gentle people help me please?
Thanks
|
|
|
 |
Ken Hardwick
|
| Posted: 06/18/2002, 11:54 AM |
|
You can add your input parameters in your custom SQL...
select count(*) as total_number_of_records from table_name
where
field1 = ' & getparm("xxx") & "'
Note..I left the last " off on purpose...
Ken Hardwick
Norman,Ok
Xavier <nobody@nowhere.invalid> wrote in message
news:aen4fi$nro$1@news.codecharge.com...
> Hello CC experts,
> I've a search and a grid form in the same page.
> Grid shows selected records by creation date and company code.
> I put a second grid form in. It's just a one-field (label) grid,
> and in its SQL form properties I checked "use SQL string" and wrote this:
> select count(*) as total_number_of_records from table_name;
>
> In this way I always get the total number of not-null records in database.
> I'd like to have the correct number of records selected, but once "use SQL
> string" is selected
> it's impossible to set some input parameters in Input form properties,
> except the variable used for the select count.
>
> Can any gentle people help me please?
>
> Thanks
>
>
>
>
|
|
|
|
|
