Access violation during exectuing a query runtime and designtime [V 5.00.0.4]

Thomas J. · Post by **Thomas J.** » Wed 28 Mar 2007 12:00

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!

Antaeus · Post by **Antaeus** » Thu 29 Mar 2007 06:55

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.

Thomas J. · Post by **Thomas J.** » Thu 29 Mar 2007 07:38

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;

Antaeus · Post by **Antaeus** » Thu 29 Mar 2007 08:47

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next build of MyDAC 5.