Part 1:
I'm creating a view using the following syntax:
CREATE SQL VIEW myview AS SELECT *, .f. AS lSelect FROM Inventory
Is this safe? (I'm wondering because it seems to be unnatural use of a view)
Part 2:
My purpose for doing this is that this view is bound to a grid and I need the lSelect field to indicate that certain records are selected. I use the Dynamic ForeColor and BackColor of the cells to highlight 'selected' rows so they stand out to the user and appear as selected. The user can Shift-Click to select or deselect records.
I arrived at this solution because I am trying to make a grid have multi-select capability like a listbox. I want the user to be able to select multiple records by shift-clicking, clicking and dragging, or using shift + arrow keys, has anyone seen code to make a grid act like this?
--
David Mann
Software Developer
"I don't believe in 'isms', I just believe in me" -- Ferris Bueller