facebook

Add ability to insert data into a table via Edit Data window

  1. MyEclipse IDE
  2.  > 
  3. Feature Requests
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #242488 Reply

    In the MyEclipse Database Explorer perspective, there is the ability to edit existing data in a table when you right click on a table in the database browser and select “Edit Data”. Could you add the ability to insert new data into a table via this editor?

    I also use Tora on Linux. I can almost completely do away with Tora because of the nice features in MyEclipse, but not quite. There are still a few things I can do better there like the ability to insert a row into a table. In Tora, there is empty row after the last row in the table editor. You can insert data into it and click a button to insert it. You can also select a row and delete it.

    A couple more features I like in tora is that I can have multiple SQL statements in a single SQL Editor window. I can choose to execute the current statement or all statements in a window. The current statement is identified by the statement that has the cursor in it.

    There is also a button to commit work. This is nice can you make several changes before commiting. Then commit via the button.

    #242526

    Riyad Kalla
    Member

    I also use Tora on Linux. I can almost completely do away with Tora because of the nice features in MyEclipse, but not quite. There are still a few things I can do better there like the ability to insert a row into a table. In Tora, there is empty row after the last row in the table editor. You can insert data into it and click a button to insert it. You can also select a row and delete it.

    I understand the request, MySQL Query Browser does something like this as well, quite nice for quick edits.

    A couple more features I like in tora is that I can have multiple SQL statements in a single SQL Editor window. I can choose to execute the current statement or all statements in a window. The current statement is identified by the statement that has the cursor in it.

    Good suggestion

    There is also a button to commit work. This is nice can you make several changes before commiting. Then commit via the button.

    Got it.

    I’ll file the first two suggestions and ask the DB team if the last one is a big enough pain to postpone until a later date. Thank you for the requests.

    #242527

    Riyad Kalla
    Member

    Hmm it seems #1 and #2 are already filed.

    For #2 you have to highlight the statement currently and then execute it, simply placing the cursor doesn’t do it. Does that work as a temporary workaround for you for the time being?

    #242532

    For #2 you have to highlight the statement currently and then execute it, simply placing the cursor doesn’t do it. Does that work as a temporary workaround for you for the time being?

    This works fine. Marking the current statement by positioning the cursor in it is a tiny bit less work, but the way it currently works is fine.

    If you have a popular GUI database admin tool, like TOAD, you might see how it handles this, and then copy it. That way it will be intuitive for new users.

    When I was testing, I noticed a very nice, cool feature. When I have multiple SQL statements in an editor, I get each result in a separate tab. Very nice. Tora definitely doesn’t do this. Thanks!

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Add ability to insert data into a table via Edit Data window

You must be logged in to post in the forum log in