If DBGrid row not selected

[lespaul]

I have a DBGrid that has a list of people who were scheduled to show up for an event. I want to have the user select the people who were absent (multi-select is true) and then for all the people NOT selected update the database. Is this possible?

Thanks!
Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[lespaul]

I also would like when the user selects a row for an absent person, the row change color. I have used some code from the FAQ on coloring the rows, but it doesn't keep the color, once I move to a different row, the first one loses it's color!

Thanks for any suggestions! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[lespaul]

One more thing! The multi select is acting WIERD!! When I open the form with the DBGrid, I select a row (which I'd like to change color at this point), when I use the Ctrl Key it doesn't look like the first one is selected anymore. And after I try to select a few more rows, the entire grid gets selected! Thanks again! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[lespaul]

Ok I have changed some options so it works a little better. I have RowSelect and AlwaysShowSelection set to True so the color stays now. But Row One is ALWAYS selected! Also how do I unselect a row? And should I have to select the record twice for it to really select it? It has a weird > with a dot inside it, or just a dot or a solid >. I'm sooooo confused!!

Thanks for any assistance! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned