Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.

Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.

clearing values from a column

hey all,
how would i clear values for a column for all rows but not delete the row?
thanks,
rodcharHi,
Use Update command and set the column value with null
UPDATE TABLE
SET COL1 = NULL
Thanks
Hari
SQL Server MVP
"rodchar" wrote:

> hey all,
> how would i clear values for a column for all rows but not delete the row?
> thanks,
> rodchar|||"Clear" meaning what' You have to decide, for each datatype (for each
Column) what value will mean "Cleared" For a chacacter type column that's
not hard, Just an Empty String, I guess makes the most sense, but for
numeric or date columns, it's bit harder, The value you choose may be a
meaningful value in rows that are not "Cleared"
If the Columns allow Nulls, you could use null, but that's not really what
null iod supposed to be for, (it means UNKNOWN) so I wouldn;t recommend that
,
(UNless you MEAN Unknown when you say "CLeared")
"rodchar" wrote:

> hey all,
> how would i clear values for a column for all rows but not delete the row?
> thanks,
> rodchar|||You can do:
--if column is defined as nullable
update tb
set col=null
-oj
"rodchar" <rodchar@.discussions.microsoft.com> wrote in message
news:D8369B7B-3634-4A8B-88FC-23D948D18D53@.microsoft.com...
> hey all,
> how would i clear values for a column for all rows but not delete the row?
> thanks,
> rodchar

Clearing a Table

I have entered some temporary values in a table located in an SQL database, to test a project to see if it was working. Now I want to remove the values so that later, the program I have created will be capable of using the table for it's true purpose. However, when I try to delete the values located there, I receive an error message. How can I clear the table?

you have not mentioned the error. Anyhow, the possible problems are either Permission or the table which you are deleting may have child tables which referencing this table. Check the permision first. For reference issue delete the child tables data first and then delete the master table

Madhu

|||

Most likely, you have a relationship (PK-FK) established between this table and another. (But, as Madhu suggested, it could also be a permission issue.)

Please post the entire error message so that we can better assit you.