Dharma Mulya
|
| Posted: 12/02/2002, 7:57 PM |
|
Can anyone help me to do the following. I have a set of data that were mark
inactive in the database. I don't want to show these data in the grid. How
do you do it.
I am using CCS. Thank you in advance.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/02
|
|
|
 |
Vic
|
| Posted: 12/02/2002, 11:33 PM |
|
Hi Dharma Mulya,
You may add this condition in SQL, for example so :
1. Open DataSource window for yours Grid
2. Add TableParameter (button +)
3. Define your condition like:
Field name = < your DB field >
Conition =equals
Paramter source = true
Paramter source Type = Expression
It will add Where condition <your DB field> = true
Vic
"Dharma Mulya" <dharma@supreme.com.my> wrote in message
news:asha2t$3g5$1@news.codecharge.com...
> Can anyone help me to do the following. I have a set of data that were
mark
> inactive in the database. I don't want to show these data in the grid. How
> do you do it.
>
> I am using CCS. Thank you in advance.
|
|
|
|
Dharma Mulya
|
| Posted: 12/13/2002, 2:51 AM |
|
TQ this works.
See you with my next problem next time. Bye
"Vic" <victor.tciba@yessoftware.com> wrote in message
news:ashmof$qbo$1@news.codecharge.com...
> Hi Dharma Mulya,
>
> You may add this condition in SQL, for example so :
> 1. Open DataSource window for yours Grid
> 2. Add TableParameter (button +)
> 3. Define your condition like:
> Field name = < your DB field >
> Conition =equals
> Paramter source = true
> Paramter source Type = Expression
> It will add Where condition <your DB field> = true
>
> Vic
>
> "Dharma Mulya" <dharma@supreme.com.my> wrote in message
>news:asha2t$3g5$1@news.codecharge.com...
> > Can anyone help me to do the following. I have a set of data that were
> mark
> > inactive in the database. I don't want to show these data in the grid.
How
> > do you do it.
> >
> > I am using CCS. Thank you in advance.
>
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/02
|
|
|
|
|
