Execute for Update

[avallach]

Greetings,

I have a table that when I execute for update (F8) on it, and the window pulls up for me to edit the data in, that I can't see all of the fields to edit. I scroll over and there are more fields that won't display. If I put my cursor into a record and arrow over I am able to see a portion of one the fields, but I can't see the rest of them. Sometimes after I edit a comment field and then cancel I can scroll over and see the rest, but the scrollbar doesn't move (it is all the way at the end) and then I end up loosing those columns if I scroll back.

Here is my table structure if this helps.

CREATE TABLE `sstaff_AppJobChoice` (

`app_id` int(11) unsigned NOT NULL default '0',

`app_year` varchar(4) NOT NULL default '0',

`choice` int(11) unsigned NOT NULL default '0',

`LID` int(11) unsigned NOT NULL default '0',

`JID` int(11) unsigned NOT NULL default '0',

`status1` tinyint(3) unsigned default '0',

`status2` tinyint(3) unsigned default '0',

`comments1` text,

`comments2` text,

`statusdate1` date default NULL,

`statusdate2` date default NULL,

PRIMARY KEY (`app_id`,`app_year`,`choice`)

) TYPE=MyISAM

Thanks,

Daniel

[Ritesh]

Can you upload a screenshot of the window when the problem is occurring?

[avallach]

Sure,

I hope I do this right.

The image should show me scrolled all the way over. You can see a partial heading of the next column, but the current column extends into it from the looks of it.

[Ritesh]

Thanks for your help.

[Author]

Posts