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

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 7, 2007 at 4:16 pm in reply to: Problem Running A Stored Procedure #23376
    RobUK
    Member

    2) Nothing meant by that at all Peter, just my inexperience using this stuff.

    3) Cheers for this. Currently we have MySQL v5 and SQL Yog v5.02 (free version). What I need to do is to get a bit of SQL run that simple updates some records on some tables weekly, I take it I won't be able to do this with my current version of software.

    Upgrading to the latest version of MySQL and SQL Yog Enterprise would enable me to achieve my goal? Or are there any other methods in which I can get a copy of lines of SQL run about our MySQL database weekly?

    Cheers.

    February 6, 2007 at 4:31 pm in reply to: Problem Running A Stored Procedure #23374
    RobUK
    Member

    Cheers guys, managed to sort it in the end. If I put my active cursor in the actual call to the stored procedure, it works. Because I was copying and pasting the call and then leaving the cursor outside of the semicolon at the end of it, this made it fail.

    Crazy program!

    One other question, is there a way to set up mySQL to run a stored procedure at a certain time each week? Reason being I will eventually need it to run this particular SP that I'm working on once weekly. Can this be set up with SQL Yog?

    February 6, 2007 at 3:46 pm in reply to: Problem Running A Stored Procedure #23372
    RobUK
    Member

    Hi Peter, still having problems with this. Where do I make this call from? I'm currently trying it in the QUERY tab of the window but no luck. I was initially trying to run my stored procedure by pressing F5 to execute it, but that was just displaying the message I posted earlier.

    Cheers.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)