Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
trilju2005
Starting Member
3 Posts |
 Posted - 2012-03-08 : 13:12:26
|
I have to create a stored procedure that will view data from a table. The user will audit the data, with paid dates. The user comes back to the view report, check/select all lines that have the same paid dates to change. The user will enter the paid date, then click a button and update all the records selected. Will I need to have the checkbox field in the table?Is it something that the user only has to see in the viewed report?I am just not sure how to add this checkbox OR if it is even possible to have a checkbox. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-08 : 14:47:03
|
| looks like its a presentation question. You need to do coding of checkbox using your front end language like html then use events to capture selected checkbox info. Based on what all are selected you need to pass a boolean value through form to application which will pass it down to your database by means of store procedure which will have a bit field. Then in stored procedure you can check this bit field and do required actions in your table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
trilju2005
Starting Member
3 Posts |
Posted - 2012-03-08 : 16:23:35
|
| Thanks, I didn't think it was possible. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
trilju2005
Starting Member
3 Posts |
Posted - 2012-03-08 : 17:00:32
|
| Wanted something with a gridview then have a checkbox to select all line items that have the same date to update then click a button to update the line items |
|
|
|
|
|
|
stored procedure, update, check checkbox