#318 Not possible to edit data after SQL query

2.1final
closed-fixed
Rob Manning
9
2006-09-28
2005-12-02
VAdamec
No

I'm using mysql-connector v3.1.12, rc2 SQuirrel and I
can't edit data from SQL query - simple select (select
* from <unique_table_name>). I could edit data only
from main session screen (there is 'Make Ediatable' in
menu in SQL not). Database is MySQL 4.1.14. Tested on
Win XP Pro and SuSe Linux.

Discussion

<< < 1 2 3 4 > >> (Page 2 of 4)
  • Rob Manning
    Rob Manning
    2006-01-14

    Logged In: YES
    user_id=1287991

    I think I managed to reproduce the issue (or perhaps a
    related one.) Steps to follow:

    1. Create a user and two database catalogs.
    2. Give the user access to both catalogs.
    3. Login as the user using catalog "A" in the connect url:

    jdbc:mysql://localhost:3306/A

    4. Create a table in catalog B like:

    create table B.test ( id integer);

    5. Insert some data into B.test:

    insert into table B.test values (1);

    6. Select data in the SQL pane from B.test:

    select * from B.test;

    7. Right-click on the results table and select "Make Editable"

    8. Try to change the value to 2 and press enter.

    9. Notice an error dialog stating that the table could not
    be found.

    Rob Manning

     
  • Rob Manning
    Rob Manning
    2006-01-15

    • status: open --> closed-duplicate
     
  • Logged In: NO

    IMHO it is not same as bug 1250514 - because in this bugs
    is, at least, ¨Make Editable¨ item in left-click menu. But
    I haven´t got this in menu (only in Session Properties).

     
  • Rob Manning
    Rob Manning
    2006-01-16

    Logged In: YES
    user_id=1287991

    Ok, we'll leave it open then ;)

    You are correct, it is a slightly different problem. If you
    had a "Make Editable" item in your context menu, then the
    other bug might be exposed.

    Rob

     
  • Rob Manning
    Rob Manning
    2006-01-16

    • status: closed-duplicate --> open
     
  • VAdamec
    VAdamec
    2006-01-19

    Logged In: YES
    user_id=1292032

    Items in menu depend on driver which is used or it is affect
    by other part of squirrel? I found only one mysql driver -
    mysql connector, could I try another driver (if exist)?

     
  • Rob Manning
    Rob Manning
    2006-01-19

    Logged In: YES
    user_id=1287991

    VAdamec,

    I don't think that menu is driver-specific.

    So what is it exactly that you see when you right-click on
    the result tab from a SQL query? If I understand you
    correctly it is apparently not a menu with the following
    options:

    Copy
    Copy as HTML
    Copy as SQL IN Statement
    ---
    Make Editable
    ---
    Select All
    ---
    Print

    If that is the case, what is in the right-click menu?
    A screenshot might be useful too!

    Rob

     
  • VAdamec
    VAdamec
    2006-01-19

     
    Attachments
  • VAdamec
    VAdamec
    2006-01-19

    Logged In: YES
    user_id=1292032

    Here is screenshot

     
<< < 1 2 3 4 > >> (Page 2 of 4)