timauld
Posts: 5
|
| Posted: 08/17/2005, 12:19 PM |
|
In a Record grid, I need to be able to programatically cancel the display of a row depending on certain data conditions. Can anyone tell me how to do this?
Regards ... Tim.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 08/17/2005, 12:32 PM |
|
What do you mean by record grid? Is this is a record form or grid?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dataobjx
Posts: 181
|
| Posted: 08/18/2005, 5:57 AM |
|
You may need to consider modifying your sql to exclude certain records, but it sounds to me like this is supposed to be dynamic. In this event, If you're using SQL Server, your best bet will be to use what's called a Cursor driven stored procedure.
If you search the internet, you'll find plenty of examples. The cursor driven stored procedure allows the stored proc to dynamically exclude records from the out-going recordset - programmatically...
This is likely the best bet, as once the recordset is released to the grid - the grid only knows how to display all of it.... thus you need to programmatically confine the recordset it receives to begin with.... and this is where the cursor driven stored procedure would come into play.
Note: Cursor driven routines can be difficult to build and you may need to be more persistent than usual to make it work as you need it to. Having said that, they work great once completed.
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
|
|
