f11: Edit data, A text box fills Window?

This topic is empty.

Viewing 11 reply threads

Author

Posts
- August 6, 2004 at 12:11 pm #8522
  
  zzapper
  Member
  
  Hi, v3.71
  
  When I want to update the data in a mysql table, I press F11, but I can't “see” some of the columns because a text field fills practically the whole width of the screen!!
- August 6, 2004 at 5:29 pm #16145
  
  peterlaursen
  Participant
  
  Why don't you attach a screenshot? Its hard to know exactly what you are talking about !
- August 6, 2004 at 6:14 pm #16146
  
  Ritesh
  Member
  
  Table structure and a row of data would be nice 🙂 We can use them to sort out the bug (if there are any).
  
  Also, what is the screen resolution you are working on?
- August 9, 2004 at 9:22 am #16147
  
  Shadow
  Member
  
  It's a display problem, was present in previous versions as well. Let's say, you have a table with fields named a, b, c, and a is of text type. If “a” contains any data, then SQLyog appears to expand the size of “a” column to the byte length of the largest entry in “a” field.
- August 10, 2004 at 1:36 pm #16148
  
  peterlaursen
  Participant
  
  I think not only “SQLyog appears to expand the size of “a” column to the byte length of the largest entry in “a” field” but the columnwill be as wide as the field definition in my experience.
  
  But I'm still uncertain if I understand you right. Please upload a scrren-shot!
- August 11, 2004 at 6:55 am #16149
  
  Shadow
  Member
  
  No, the largest actual length is used. Simply create a table with a column of VARCHAR(100) and press F11!
- August 20, 2004 at 1:05 pm #16150
  
  zzapper
  Member
  
  Hi,
  
  Sorry been on hols!!
  
  My problem was that everytime I saved to mysql I was suffixing an extra space to my text field, this was growing the width of the text field to gradually fill the screen. Solution was to always trim spaces before updating (I guess this is good MYSQL practice?).
  
  YOG DOES HAVE A PROBLEM HERE THOUGH, I mean my text field could easily have a lot of text in it!!!
  
  Should it be reported as a buglet???
- August 20, 2004 at 1:52 pm #16151
  
  Ritesh
  Member
  
  Have you unchecked the option Truncate column headers to Max. data size in Tools -> Preferences?
- August 20, 2004 at 2:13 pm #16152
  
  zzapper
  Member
  
  Ritesh,
  
  That's it Uncheck “Truncate column headers to Max. data size in Tools -> Preferences?”
  
  Now we're sucking diesel!!!
- August 20, 2004 at 4:27 pm #16153
  
  Ritesh
  Member
  
  zzapper wrote on Aug 20 2004, 02:13 PM:
  
  Ritesh,
  
  That's it Uncheck “Truncate column headers to Max. data size in Tools -> Preferences?”
  
  Now we're sucking diesel!!!
  
  Sorry for my ignorance but I am unable to understand what you meant?
- August 20, 2004 at 4:42 pm #16154
  
  zzapper
  Member
  
  Ritesh
  
  Now we're sucking diesel' (Now we're making progress! of Irish origin)
- August 20, 2004 at 5:43 pm #16155
  
  Ritesh
  Member
  
  zzapper wrote on Aug 20 2004, 04:42 PM:
  
  Ritesh
  
  Now we're sucking diesel' (Now we're making progress! of Irish origin)
  
  😀 😀
  
  Great to know that SQLyog works for you 😀
Author

Posts