Can you please implement SQL preview?

I'm an almost churning user from Navicat for several years mainly because I can no longer afford their products. One of the feature that they have but SQLPro doesn't seem to have is SQL preview. In Navicat, whenever you make any changes in the UI, they will show you the corresponding SQL to be executed. Can you please implement it and this will be the final straw for me to churn from them. Thanks.

11replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi. I'm not 100% sure what you mean. Currently in SQLPro when you alter a table, drop a table, or as of the latest updates edit row data (https://user-images.githubusercontent.com/3160528/69152971-c7755280-0ab3-11ea-853e-c1ffadec1f1b.gif) you will be provided with the SQL action that occurs.

    Like
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • Reported - view

      Kyle  thanks that's exactly what I meant. However, I didn't see it when I alter the table, I mean to add a column, or drop an index. Or there were there but I didn't see?

      Like
    • Qian Chen what type of database are you connecting to? (MySQL, Postgres, mssql, other)?

      Like
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • Reported - view

      Kyle Hankinson mainly mysql. I assume the ui is helping to generate the sql before it’s sent over to the db. So I think the ui should have the knowledge of all sql before submitting to the db server. 

      Like
    • Qian Chen what version of the app are you using? Unless it’s a really really really old version, it should be showing a preview of any alter database actions for mysql.

      Like
    • could you post a screenshot of the ‘about’ dialog?

      Like
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • Reported - view

      Kyle Hankinson   

      Like
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • Reported - view

      This is what I downloaded from Apple's App store as of now.

      Like
    • Qian Chen yep, so if you make a change then hit Apply, you actually get prompted with the code thats going to run (see below gif). I'll rename the apply dialog to 'Preview and Apply'.

      Like 1
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • Reported - view

      Kyle Hankinson thank you! I will get a license soon. 

      Like
      • Qian Chen
      • Qian_Chen
      • 2 mths ago
      • 1
      • Reported - view

      Kyle Hankinson Thank you!

      Like 1
Like Follow
  • 2 mths agoLast active
  • 11Replies
  • 19Views
  • 2 Following