|
|
|
|
| Re: How to enable editing in Toad [message #417728 is a reply to message #412564] |
Tue, 11 August 2009 05:10   |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Well, you could open Schema Browser, navigate to a table you are about to update, set filter (unless you want to update all records - there might be millions of them) and overtype old values to new ones.
You can expect problems, such as violation of different constraint types (uniqueness, non-existent values in foreign key relationships etc.) and, most of all, the fact that changes you commit are irreversible. You don't know previous values any more, and, if you aren't careful enough, you may even lose records you have updated from sight (for example, navigation to a different table and return back into the updated one might display nothing because filter doesn't see these records any more as you've updated these values).
Manually written UPDATE statement leaves a track (you know what you've updated and where). Your way ... well, is risky. Do you want to take that risk?
|
|
|
|
|
|
) 2 Votes
] 
Blog
Search
Help
Members
Register
Login
Home
