[sitthichaikk]

I may repeat..

Quote:

The main topic is slow down when scroll on mouse whell and scroll pointer. It's gone…….

Quote:

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

The table in result window not get even scroll when just click select on tab. That is my point.

Quote:

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.

fine… I got your point.

[sitthichaikk]

Today I try to download the 4.05 BETA again.

Wow….

I found the point differance between you and me.

You side….. you just click on your SQL command on SQL window and you click on “Execute Current Query” (Play button) or F5

My side….. I just cover my SQL command on SQL window and I click on “Execute Current Query” (Play button) or F5

that same one line SQL command but stop button will not show if i do cover my SQL command.

btw i just give you what i see on my side.

The main topic is slow down when scroll on mouse whell and scroll pointer. It's gone……. 😆 😆 😆

I found two things with new download.

One…

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.

Two..

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.. 😮 😮

my idea

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”.

The “tab data” always show all record from first record to 1000(default number on that tab). It's helpfull if user know the range number of data. But if “tab data” show same as “tab result” It's a good things.

Because sometime user may not know exactlly record number. They want to have show in “tab result” and also canable edit in “tab data”.

Please try it.

Thanks

[sitthichaikk]

Ritesh wrote on Mar 31 2005, 09:47 AM:

How many rows are you trying to display?

Whenever you execute a query, the execute query button (green color) in the toolbar is replaced by a red stop sign. Click on it to stop a currently executing query.

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

How many rows are you trying to display?

28660 records.

Whenever you execute a query, the execute query button (green color) in the toolbar is replaced by a red stop sign. Click on it to stop a currently executing query.

I haven't see anything change on toolbar. I'm click on execute query button then Hour Glass showing up, but the query button still green color until finished result.

May i miss some options or … ?

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

I uncheck it . That work's fine.

Thanks

[sitthichaikk]

Ritesh wrote on Mar 30 2005, 01:25 PM:

From v4.05 BETA you can actually stop a query while its being executed.

How can i stop it ? I haven't see the “stop” buttom in menu.

The SQLyog 4.05 BATA. It's show in result window very fast… 😀 😀

But if I scroll up or down with mouse wheel or move pointer by mouse It's still slow display in result window(tab “1 result”).

and the columnin result window, That you do auto column width. Can you fix mininum width or make it auto column width with range number?

example…

If “field column” have chareter less than < 5 chars and "data column" less than < 5 chars. It's will show only 5 chareter of that column. If “field column” have chareter less than < 5 chars and "data column" more than >10 chars. It's will show only 10 chareter of column.

If “field column” have chareter more than >10 chars and “data in column” less than <5 chars. It's will show only 10 chareter of column.

If “field column” have chareter more than >10 chars and “data in column” less than > 10 chars. It's will show only 10 chareter of column.

That mean the column width can be 5 to 10 chars.

Thanks.

Any idea are welcome.

[sitthichaikk]

I do retrive data from database server,

I'm taking about Result Window. 😀

[sitthichaikk]

The lastest 4.02 BATA version work fine on set user privileges, But Manage Permissions has problem below.

This is original line query from history.

Quote:

insert into mysql.db ( host, db, user, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, grant_priv, references_priv, Index_priv, alter_priv ) values ( '%', 'nn', 'nn', 'y','y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y' )

Quote:

insert into mysql.db ( host, db, user, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, grant_priv, references_priv, Index_priv, alter_priv ) values ( '%', 'nn', 'nn', 'Y','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y' )

After. I changed 'y' to 'Y' then do manual execute this query. It's work fine.

Note: This problem occured when I only use SQLyog remote to server.

[Author]

Posts