[Ritesh]

@Pjotr_du_mat: What port forwarding (local port under tunnel tab) value are you providing for SSH Tunneling?

[Ritesh]

SQLyog v4.05 BETA 3 will automatically delete the length value for datatypes not supporting length.

[Ritesh]

Just press Del when the focus is in the len column.

[Ritesh]

Quote:

After my result is show on “result window” then I try to click between “result tab” and “data tab”. if i not click on the record in result window . It's cann't scroll up/down my data.

I am not sure if I understood your problem. Can you explain it a little more?

Quote:

On result window. the sort function by click on field name on “result tab” is disable.

but on “data tab” It 's work…and sloooooow

Sort and filter for Result Tab will be implemented in v4.1. When you try to sort data in Data tab, SQLyog actually sends SQL query with order by clause to MySQL. So it is MySQL which is slow in returning the data.

Quote:

Once…It's done on query command the result will show on “tab result”. and in “tab data” will same as “tab result”. if somebody want to edit in record, they can edit on “tab data”.

I think you are confused between the Result and Data tab. Result tab will show you data returned from a query. It even allows you edit data in the result. This means that you can execute a query with multiple tables and edit data of the table(s) simultaneously.

The data tab simply shows data from a particular table. This is helpful if you just want to view through the data in a table without writing the corresponding SQL code.

Quote:

The “tab data” always show all record from first record to 1000(default number on that tab).

You can change the limits using Tools->Preferences

[Ritesh]

That is currently not possible in SJA. You can only define tables that needs to be sync. You cannot specify tables that do not need to be sync.

[Ritesh]

I believe you are using BETA 1.

Please download v4.05 BETA 2. We have added the option again in the Table menu.

[Ritesh]

Yes.

Please read the SJA Schema Documentation at http://www.webyog.com/sqlyog/sjaschema.html. You can do this using the tables element.

[Ritesh]

Quote:

Possible solution = 'View Data as Resultset' and 'View Data for Editing'.

View Data as Resultset = Table -> View Data

View Data for Editing = Table -> Insert/Update Data

Quote:

If the column is full of 'null' values the column is almost completely collapsed.

Could the 'result tab' be more like the 'data tab' with the column widths set by the title not the data.

Have you unchecked Tools -> Preferences -> Truncate Column Header To Max Data Size?

[Ritesh]

I am not sure about button with the grid/arrow. Can you post a screenshot?

[Ritesh]

It should not crash.

Can you tell me what do you mean by – if you change from one thing to another?

Your information will greatly help us resolving all the bugs and make SQLyog a better product.

[Ritesh]

Hmmmmmm….

Any particular reason?

[Ritesh]

Are you using Tunneling or Direct connection?

Can you send me data with a sample query?

[Ritesh]

Thx.

Bug confimed. Will be fixed in next BETA build.

[Ritesh]

You dont need F11 or Insert/Update 😀 Just select the table in ObjectBrowser and select the Data Tab in the Resultwindow.

You dont need F8 or Execute for Update 😀 Just execute a query and you can edit the result right there in the Result Tab. Initially, the result will be in read-only mode. Just select a table to edit from the drop down window and start editing the result in the grid.

The above two features are improvements in 4.05 BETA.

Quote:

F£ display List of Function keys is corrupt!?!

???

[Ritesh]

Stop query.

[Author]

Posts