Yes – I can modify character columns and the data gets saved. I’ve enclosed a screenshot.
As long as I enable the pencil, I can edit character columns, hit the "check mark" and the data gets saved. The same SQL statement will general a new result set with the modified column.
Any useful front-end should allow modifying the columns of a row without having to type an SQL statement, and this toad edge apparently does that just fine for character columns.
On 1/25/2018 10:52 AM, dvohra10 wrote:
** RE: I cannot enter integer values for update a column**
Reply by dvohra10
The row of data generated with SQL statement is the query result set. Even the character columns should not be modifiable. Does the modified data get saved? Does the same SQL statement generate a new result set with the modified character column? To modify a data row run a DML (UPDATE SQL statement).
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad Edge - Forum notifications altogether.
Flag this post as spam/abuse.