Re: Change ROW colors in a grid.

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

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 I ... 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 ...
    (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 ... Be sure to use the "Nofilter" clause if you use a cursor. ... 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: Change ROW colors in a grid.
    ... If you want to do it via a view, you can have temporary database that has ... TonySper wrote: ... I select one of the records from the cursor and modify that record ... 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.
    ... You can create a temporary database on the fly that only contains views. ... TonySper wrote: ... I select one of the records from the cursor and modify that record ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)