sqlyog refresh table view

Posted on 2009-04-17
Last Modified: 2012-05-06
using sqlyog for windows, I press f5, 'refresh object browser'  and the 'table data' will not be refreshed after querry

however when I close and reopen sqlyog program
'table data' is refreshed
Question by:shopjd
    LVL 11

    Expert Comment

    In preferences, do you have "Automatically refresh table" checked?

    LVL 12

    Expert Comment

    Your machine has an issue definitely because a refresh of the log should show new items.
    As a work-around access syslog from SQL Server Management Studio (SSMS) if you have it.
    Open up the server, go to management folder, click SQL server logs and the log file viewer will pop up. Check only Windows NT.
    Please note that a refresh here will show the new records in the syslog.
    The only disadvantage is that it might take a few seconds while loading the rest of the log but shows the items on top immediately.
    Chris Musasizi.

    Author Comment

    i cant find automatic refresh in preferences
    and when I click refresh, nothing happens

    As a work-around access syslog from SQL Server Management Studio (SSMS) if you have it.
    how can I get this program, I am running mysql
    LVL 12

    Expert Comment

    SSMS is part of Microsoft SQL server admin tools which you only get on a SQL server CD (when you install the tools) but it can as well access syslog.
    Since you do not have it, then you don't have a choice other than accessing the logs the default way otherwise installing it would have helped.

    Author Comment

    how can I make sqlyog refresh
    can I email them
    LVL 12

    Expert Comment

    If you righ-click on the database and choose "refresh object browse", then a refresh will happen.
    May i know which version os sqlyog you're running?
    LVL 12

    Accepted Solution

    I also just discovered that you actually can switch F5 and F9 functionalities and if you do, then F5 will execute queries (it will not refresh sqlyog anymore).
     To undo this (or even check your status), click tools > preferences > other and then look at the option "switch F5 and F9 functionalities". I hope this is what is affecting you.
    To click your trouble shooting off, modify your test database by creating an object and then right click and choose to refresh. If it shows the changes, then refresh is working but needs the right set of preferences to use F5 as a shortcut.
    Please note that the automatic refresh of data will only work on forcusing, and if the option is enabled (check your options).
    All the best.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Help with SQL joins 9 32
    Not Like IN Access Query not Working 10 31
    report c# 9 59
    MySQL Select latest stock count records 11 0
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now