April 12, 2005 at 8:39 am
Hi,
I am trying to edit column values in a table using enterprise manager. I have to edit so many records. Is there a command to change the cursor to edit mode? In that way I can avoid to click the mouse each time to enter into edit mode.
Thanks,
Sridhar!!
April 12, 2005 at 10:07 am
why don't you modify the values with an update statement?
April 13, 2005 at 8:41 am
Remi's suggestion is the best but if you have to use EM for some reason all you have to do is press the down arrow key to move to the next record while staying in the same column. The data in the cell is automatically highlighted for edit. If the rows are not consecutive try changing the underlying SQL statement to reorganize them so you can group the ones you need to edit.
HTH
Don
April 14, 2005 at 2:34 pm
If you use EM you can cause locking problems if other users are connected.
Unless you are talking millions of records I find that if I need manual updates I export the relevant records into MS Access and make the changes off-line (or give it someone else to do).
I then either generate a text file containing SQL update statements, or I DTS the file back in as a scratch table and perform my update by linking on the primary key.
In general though I would sooner use a standard UPDATE statement
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply