[Aparna]

Hi Matt,

The schema designer is designed not to keep track of the table name changes and hence will raise error messages about tables not existing upon saving. But the bug here is that SQLyog saves the schema XML in spite of throwing the error message and this will be rectified. So henceforth if the tables are renamed/dropped after being loaded into the schema designer, SQLyog will throw an error message while saving the tables and will not save the tables as well.

Regards,

Aparna.

[Aparna]

Hi,

This issue has been fixed. Kindly let us know the version of SQLyog you are using. We can provide you a binary with this fix if you need it immediately otherwise it will be available in our next public release.

Thanks and Regards,

Aparna.

[Aparna]

Hi,

Quote:

I’d like to generate the create table SQL to the clipboard or the current query editor window, and then from there tweak it as needed to create the new table.

This feature is available in MS SQL Studio.

You could try the following options to get the create table statement in SQLyog:

1. If you are interested in just viewing/copying the create table statement then select that particular table and click on the info tab. This will display the create table statement for you. If you want to copy it then select the option that reads text/detailed and copy the statement into the editor.

2. If you want to duplicate the table then there is an easier option to do so. All you have to do is right click on the table, select more table operations and then select duplicate table structure/data . Once you select this, the duplicate table window will pop up. You have options to duplicate both the structure of the table and the structure and data as well. Please see the attached screen shots that will help you understand both the steps better.

Regards,

Aparna.

[Aparna]

Hi,

Please use to the link below to find sja for linux:

http://code.google.com/p/sqlyog/downloads/list.

Regards,

Aparna.

[Aparna]

Hi,

Thanks for your suggestions.

1. you don't know what was the criteria applied

In both table data and the result tab once the filter has been applied the filter icon gets enabled and if you put the mouse pointer on the filter icon then the tool tip shows the filter condition that was applied. Please see the attached screen shots.

2. only one filter at the time can be applied

Yes, at the moment filter is possible only on a single column. This enhancement might be taken into account in future.

3. To amend the filter you have to go to history copy query and amend or create new filter

Yes, currently this is the only way to make changes to a query and this will also be solved if multi column filter is considered. Please correct me if i am wrong.

4.query should be display in the query window so it can be tweaked if needed.

This cannot be implemented. It gives a wrong impression to the user that the query was executed by him/her and that the query was not a result of the filter action that the user performed.

[Aparna]

Hi,

Does this URL http://www.yourdomain.com/SQLyogTunnel.php (please replace http://www.yourdomain.com with the IP address where you have uploaded the PHP page) work when you open it in a browser?

In the HTTP tab you will find an option that says advanced. Please click on that option and check the option at the bottom that reads Always use base 64 encoding for data stream. After selecting this option please also try with different content type options available in the drop down.

[Aparna]

Hi,

This request is already there in our issue tracker:

http://code.google.com/p/sqlyog/issues/detail?id=954

Right now the priority has not been set. You will be informed once this has been implemented.

Thank you for using SQLyog

Regards,

Aparna

[Aparna]

Hi,

Quote:

Sometimes autocomplete deletes the first character immediately following the cursor. For example, if tbl has two columns named col1 and col2, suppose I type “SELECT * FROM tbl WHERE x=4”. I use cursor to highlight/select “x” then I type “tbl.” to activate autocomplete and choose an entry and press TAB to select that entry. The equal sign is deleted so I end up with “SELECT * FROM tbl WHERE tbl.col14”. (you don't have to highlight/select text, just positioning the cursor in front of an existing character is enough to show this behavior.)

The above issue is reproducible in 8.7 beta2.This has already been fixed and it will be available in the next public release.

Quote:

It also happens when listing fields in the SELECT clause. I write SELECT on one line and FROM on the next line. I then move the cursor to just after SELECT and use autocomplete, and the newline is deleted so that FROM moves up to the same line as SELECT. Unfortunately, I cannot replicate this behavior on demand, but it absolutely has happened to me several times, it is quite noticeable.

This issue is not reproducible at our end in 8.7beta2 Ultimate version. Could you please give us more details on this one?

Regards,

Aparna

[Aparna]

Hi,

Quote:

I've just started to use the Schema Designer feature, and whilst handy it is driving me mad as I can't see any way of moving a group of tables all at the same time.

Well i am not really sure which one of the two options(mentioned below)you are talking about.

1.Do you want to move a group of tables from the object browser into the schema designer??? If so just double click in the Schema

Designer canvas or right click in the canvas and click on add tables. You will see a option to select all the tables using which you can select the tables you wish to add at once into the schema designer. Please see the attached screen shot(Selection_option.)

2. Or do you want to move a group of tables with in the Schema Designer canvas??? If so please confirm by replying here. We currently do not have an option to do this but we shall discuss this and update you about the same.

Thank you for using SQLyog.Feel free to pour in your suggestions.

Regards,

Aparna.

[Aparna]

Hi Joe,

Well as i understand although you have “NULL” in the grid data you want it to be exported as “EMPTY” string. Well this is not possible as “NULL” and “EMPTY STRING” are completely 2 different things. If the data in the Grid is blank then it can be exported as empty string or the other option would be to Find “n” and Replace it with “EMPTY STRING” in the Excel Application. We don't plan to implement this. Please feel free to pour in your suggestions.

Regards,

Aparna

[Aparna]

Hi Smine,

Quote:

If i select (drag mouse to highlight) the exact same query and use F8 to execute, the resultset can not be edited. Is this intended?

Well it is just that we have not implemented “Selection of a query and executing it using F8” in the EDIT mode. You can expect this in the 8.7 Beta Version.

Regards,

Aparna

[Aparna]

Hi,

Completely agree that this is confusing and a little annoying sometimes. But let us consider this scenario. Suppose each query tab has a query that belongs to tables present in different databases then to ensure that the table data tab shows the tables accordingly a “USE DB” statement needs to be fired every time you navigate between the tabs and it is not feasible. This was considered earlier but then due to the problems with implementation was not taken up. Feel free to give your suggestions regarding this if any.

Regards,

Aparna

[Aparna]

Hi,

Quote:

I don't know how to change this preference without switching to the “Table Data” tab which causes the crash in the first place.

Well as of now there is no such preference option. But the following two solutions can be used as a work around:

1. While a huge table is getting loaded please push the stop option(as shown in the screen shot stop_option) and change it to rows in a range so that the application does not crash. Does this help in your case?

2. To make sure that by default SQLyog considers rows in a range while loading any table you can do the following:

I. Goto the run option

II. Type %appdata%

III. The appdata folder opens up and inside this there will be a folder by name SQLyog. Open SQLyog and rename the file ColumnAttributes.db so that everytime you load a table rows in range will be taken as the default option.

If you have any more questions please feel free to ask us. We will try to find a solution for this.

Regards,

Aparna

[Aparna]

Hi,

Well as i understand depending on the tab you focus you want the table data tab to display that particular table and not the last viewed table ???

As now when there are multiple Query tabs, the table data tab displays the last selected table irrespective of which Query tab you move to.

Please correct me if i am wrong.

Regards,

Aparna

[Aparna]

Hi Adrian,

Nice to know that you have solved the issue by yourself. But can you please tell us the version that you are using? If you are using an older version then i request you to upgrade to SQLyog version 8.6 where this issue has been taken care of. You can save yourself the trouble of doing all those steps mentioned 🙂 Request you to try the new build and get back to us regarding any issues.

Regards,

Aparna

[Author]

Posts