Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Modying Data Via The Result Pane & F8 (Change In Behaviour?)

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Modying Data Via The Result Pane & F8 (Change In Behaviour?)

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • May 29, 2010 at 1:05 pm #30891
      peterlaursen
      Participant

      We will check this but please tell what the old and new versions you are referring to are exactly. In particular the new one.

    • May 29, 2010 at 1:08 pm #30892
      Aidan Whitehall
      Member
      'peterlaursen' wrote on '29:

      We will check this but please tell what the old and new versions you are referring to are exactly. In particular the new one.

      Sorry Peter, am using 8.4 Community. Am not sure if the previous version (which was the first one in which I noticed this) was 8.2 or 8.3 Community.

    • May 31, 2010 at 10:40 am #30893
      peterlaursen
      Participant

      We cannot reproduce this.

      1) first execute SELECT * FROM a_table

      2) now select the table in the RESULT TAB dropdown to make result set editable

      3) click in a cell once and we can paste (but note that in ENUM/SET columns you cannot) and the (red) alerting works exactly like if data are inserted from keyboard.

      Are we missing something here?  Or maybe you are trying with an ENUM column?

    • May 31, 2010 at 11:57 am #30894
      Aidan Whitehall
      Member
      'peterlaursen' wrote on '31:

      We cannot reproduce this.

      [snip]

      Are we missing something here?  Or maybe you are trying with an ENUM column?

      I didn't realise I'd hit upon a particular set of circumstances where this seems to manifest itself.

      Have just gone through the steps again and found that it happens when you:

      • execute the SQL statement by pressing F8, or press F9 and select the table name in the drop-down, and then

      • paste a value into a date field where the retreived value is NULL (this appears to be the important factor)

      The format of the value I was pasting is 2010-01-01 00:00:00

      Hope this helps.

    • May 31, 2010 at 12:19 pm #30895
      Khushboo
      Member

      Issue confirmed as described. This is a known issue if the cell value is (NULL). It has been fixed in 8.5Beta3 we released last week. Can you please verify the fix in your environment?

      Thank you for reporting.

      Regards,

      Khushboo

    • May 31, 2010 at 1:47 pm #30896
      Aidan Whitehall
      Member
      'Khushboo' wrote on '31:

      Issue confirmed as described. This is a known issue if the cell value is (NULL). It has been fixed in 8.5Beta3 we released last week. Can you please verify the fix in your environment?

      Yes, 8.5 beta 3 does fix this.

      Thanks for your help!

  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.