Re: Change ROW colors in a grid.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dan,
What is a local parameterized view ??? Have to find that one. Where
can I get info on it??
Tony

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:OAbcYz8HHHA.2236@xxxxxxxxxxxxxxxxxxxxxxx
That's exactly what local parameterized views do for you.

Automatically.

Dan

TonySper wrote:
Yes you are correct. I have been doing that but my problem comes
when
I select one of the records from the cursor and modify that record I
have to remember where the record came from in the original database
so that I can put the record back in the correct record. I want to
get
rid of the housekeeping that I am going through to keep track of it.
Just using the filtered table, picking out the record, modifying it
and putting it back eliminates all the record tracking.
Thanks
Tony

"Dave Tiffany" <dtiffany@xxxxxxxxxx> wrote in message
news:%23nxlg5zHHHA.536@xxxxxxxxxxxxxxxxxxxxxxx
TonySper,

Generally speaking, using a filtered table to populate a grid is a
bad
idea. A view or a cursor will perform better and solve your even
odd
problem. Be sure to use the "Nofilter" clause if you use a cursor.

select * from tblA where tblA.field1="ABC" into cursor XYZ nofilter.

David Tiffany

TonySper wrote:
I can change the colors of a row in a grid or browse screen by
using
the record number odd or even so that ever other row is a different
color but when I do a filter to the table and then look at the
screen
the colors are not ever other row. Is there a way to change the
color
by counting the rows or something?? I do not want to append them to
another table or create another table if possible. Any ideas would
be
welcomed?
TonySper



.

Relevant Pages

  • Re: Change ROW colors in a grid.
    ... I select one of the records from the cursor and modify that record ... Be sure to use the "Nofilter" clause if you use a cursor. ... the record number odd or even so that ever other row is a ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... using a filtered table to populate a grid is a bad idea. ... A view or a cursor will perform better and solve your even odd problem. ... the record number odd or even so that ever other row is a different color but when I do a filter to the table and then look at the screen the colors are not ever other row. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... TonySper wrote: ... I select one of the records from the cursor and modify that record I ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... I select one of the records from the cursor and modify that record I ... A view or a cursor will perform better and solve your even odd ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Modify "Push Source Desktop" filter to capture specific screen region
    ... DirectShow is very good to do this through the filter "Push Source ... I need some help to modify this ...   InterfaceType ...
    (microsoft.public.win32.programmer.directx.video)