Error with delete

[Ciaran O'Neill]

Hi,

MySql 4.0.22, MySqlFront 2.5

I'm having trouble deleting records from one of my tables. Table has the following structure:

CREATE TABLE `sales` (
`idsale` int(11) NOT NULL auto_increment,
`idacc` int(11) NOT NULL default '0',
`company` int(3) unsigned default NULL,
`location` varchar(200) default '',
`ordno` int(10) default NULL,
`orddate` datetime default NULL,
`reference` varchar(50) default '',
`rep` varchar(50) default '',
`createdate` datetime default NULL,
`idproduct` int(11) NOT NULL default '0',
`serialno` varchar(30) default '',
`swrev` varchar(20) default '',
`quantity` int(5) NOT NULL default '0',
`comment` text,
`status` int(3) NOT NULL default '0',
`active` char(1) default 'Y',
PRIMARY KEY (`idsale`)
) TYPE=MyISAM;

I have an insert statement for this table as follows:
insert into sales (`idsale`,`idacc`,`company`,`location`,`ordno`,`orddate`,`reference`,`rep`,`createdate`,`idproduct`,`serialno`,`swrev`,`quantity`,`comment`,`status`,`active`)
values(3693,251,92,'33',613813,'2005-03-31 00:00:00','',NULL,'2005-04-07 16:40:54',256,'33','33',0,'33',1,'Y');

When I try and delete this record through MySqlFront (either through GUI or own SQL statement), it just hangs. When I close with TaskManager and restart, the record has been deleted.

I can delete records in other tables in my db no problem. Anyone any clues as to why its hanging?

TIA,
Ciaran