after installing the new version the update statements are sometimes wrong.
I'm using the version 9.2.6 with C++Builder 10.2
The statement is
Code: Select all
SELECT * FROM t_gesamtpreis_detail
WHERE n_auftrag_id = :auftragId
AND n_posten_id = :postenId
Code: Select all
UPDATE t_gesamtpreis_detail
SET
n_betrag = ?
WHERE
n_id = ?
-- 282 row(s) affected.
Code: Select all
CREATE TABLE `t_gesamtpreis_detail` (
`n_auftrag_id` int(11) NOT NULL,
`n_posten_id` int(11) NOT NULL,
`n_id` int(11) NOT NULL AUTO_INCREMENT,
`n_typ_id` int(3) NOT NULL COMMENT 'kat_grp = 61',
`c_bez` varchar(50) DEFAULT NULL,
`n_betrag` decimal(19,2) NOT NULL,
PRIMARY KEY (`n_auftrag_id`,`n_posten_id`,`n_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Thomas