Page 1 of 1
Access violation during exectuing a query runtime and designtime [V 5.00.0.4]
Posted: Wed 28 Mar 2007 12:00
by Thomas J.
I get an Access violation on address 089EA455 in module 'myda60.bpl'. Reading adress 0000000C.
This error occurs on runtime and designtime
The statement which I execute is
"SELECT MAX(n_id) AS aktId FROM t_auftrag_posten_sonstige"
So I have to switch back to the old version!
Posted: Thu 29 Mar 2007 06:55
by Antaeus
I need more information to reproduce the problem. Please send me at evgeniyd*crlab*com a small test application and the script to create and fill the t_auftrag_posten_sonstige table.
Posted: Thu 29 Mar 2007 07:38
by Thomas J.
Done I thought it would be easy to reproduce, but I tried with the mysql shemata tables without errors. But the example project with database you can reproduce the error. I think the problem is the type of the column.
Code: Select all
CREATE TABLE `p_cratemaker`.`t_auftrag_posten_sonstige` (
`n_auftrag_id` int(11) NOT NULL default '0',
`n_id` int(11) NOT NULL auto_increment,
`n_typ_id` int(3) NOT NULL default '1',
`c_nr` varchar(50) default NULL,
`c_bezeichnung` varchar(45) NOT NULL default '',
`n_anzahl` decimal(19,3) NOT NULL default '0.000',
`n_gewicht_brutto` int(11) default NULL,
`n_einzelgewicht` tinyint(1) NOT NULL default '0' COMMENT '0=Gesamtgewicht; 1=Einzelgewicht',
`n_laenge` int(6) default NULL,
`n_breite` int(6) default NULL,
`n_hoehe` int(6) default NULL,
`n_behandlungsart_id` int(3) default NULL,
`m_bem` text,
`d_created` datetime NOT NULL default '0000-00-00 00:00:00',
`n_user_id` int(11) NOT NULL default '0',
`n_anzahl_rechnung` decimal(19,2) NOT NULL default '0.00',
`n_anzahl_nicht_verrechenbar` int(3) NOT NULL default '0',
`n_anzahl_geliefert` decimal(19,2) NOT NULL default '0.00',
`n_anzahl_transportiert` decimal(19,2) NOT NULL default '0.00',
`n_anzahl_auftragbestaet` int(3) NOT NULL default '0',
`n_anzahl_angeboten` int(3) NOT NULL default '0',
`c_cont_tuersiegel` varchar(25) default NULL,
`c_cont_dachsiegel` varchar(25) default NULL,
`c_cont_nr` varchar(25) default NULL,
`n_cont_typ_id` int(11) default NULL COMMENT 't_container_typen',
`n_einzelpreis` decimal(19,2) NOT NULL default '0.00',
`n_gesamtpreis` decimal(19,2) NOT NULL default '0.00',
PRIMARY KEY (`n_auftrag_id`,`n_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Posted: Thu 29 Mar 2007 08:47
by Antaeus
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next build of MyDAC 5.