sunny_99
Posts: 20
|
| Posted: 11/26/2004, 12:41 AM |
|
hi
can anybody tell me how select a single row
in CCS gird
here in the gird by defualt it update the whole form and if we want to insert it will insert all the rows
but in my situation i just want to select a single row in the gird and update that single row and insert the row
can any body help me out in thsi situation
regards
sri
|
 |
 |
sunny_99
Posts: 20
|
| Posted: 11/26/2004, 7:41 AM |
|
hi nobody has any suggestions for my situation
regards
|
|
|
|
kevind
Posts: 251
|
| Posted: 11/26/2004, 10:09 AM |
|
Hi Sunny,
Do I understand - you want to Update the row AND insert a new one ?
Can you explain more or provide a link to the page to see what you are trying to do ?
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
sunny_99
Posts: 20
|
| Posted: 11/29/2004, 1:57 AM |
|
hi
i just want to make more clear for you
in my gird i have 10 rows and i have some 7 labels and one text box which is updateable.
now the default value of the text box is 0 and when i updated some thing say 3 rows in the gird then the column get updated.
Now by default CCS deletes rows by check box i mean when i select the check box and say submit then a single row is deleted.
Now comming to the point when i do update in some rows (say 3 rows out of 10) then i just want to insert the rows which i have updated only (not the ones which i havent done any updation)
i just want to insert the rows in which there is an updated only
what CCS is doing is it is inserting all the 10 rows in to the table when i use the submit button.i dnt what this to happen
i have an sql statement running in the event (After updated) which does the insertion.
i hope i made my qustion more and elllaborate
i hope you can provide some solution for this situation
regards
sunny
|
|
|
|
kevind
Posts: 251
|
| Posted: 11/29/2004, 3:55 AM |
|
Hi Sunny,
If I understand, you want an extra insert to occur only for those rows where you've made a change in the text box.
I would try using the Custom Update property for the grid and set it to SQL, adding you extra SQL statement there. This is just a suggestion - your approach of putting the extra sql in the after insert event sounds correct though.
2nd thought - if you are loading the text box with a defaut value of zero before showing it CCS may be interpreting this as an update to the row. Try not loading the text box with Default Value.
Someone else may be able to shed some light on this though.
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
