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

6.0 Execute Query F5

forums › forums › SQLyog › Using SQLyog › 6.0 Execute Query F5

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 5, 2007 at 3:59 pm #10364
      MRC
      Member

      When I Alter Stored Procedure in 6.0 the Execute Query F5 action is greyed out. That wasn't the case in 5.30. As long as I only have one stored procedure loaded and no other queries I can use Execute All Queries Shift + F5 but that seems a little odd.

      How do I execute a stored procedure in 6.0?

    • June 5, 2007 at 4:12 pm #24117
      peterlaursen
      Participant

      For historical reasons the 'common' query tab an the 'advanced' or 'special' query tabs for MySQL objects have a little different functionality.

      The 'common' one supports 'execute (single statement)' and 'execute all'.  the 'special tab type only the last one.

      The historical reason is that when 5.0 was introduced the tokenizer code of the editor would not handle DELIMITER properly.  That is history and I personally think we should remove the 'special' tab type.  The 'common' one handles everything now.

      The answer is that from a 'special ' tab you can 'execute all' (double arrow icon).  Or you can copy the statement to a 'common' tab.

      Actually in early 5.0 the 'execute' was greyed out too, but became 'greened in' again in later 5.x builds.  By mistake I think!  It always 'executed all'.

    • June 5, 2007 at 4:13 pm #24118
      peterlaursen
      Participant

      “How do I execute a stored procedure in 6.0?”

      as always: you call() it.  But I think you mean: how do I execute a create/alter PROCEDURE statement?

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