I have a great problem with your new version.
I downloaded, installed and my customer ask me for a new version of my app. I sent a new version of my app with your BIG BUG!!
I searched for the problem the half day. At the end I found the property KeyFields which is not working for a table. Maybe for more then one table or not. I don't know!
First I used a simple TMyTable component which didn't work. Error Update failed found 652 records (it was an insert).
I tried a TMyQuery component and simple SELECT * FROM t_transport_auftrag WHERE d_deleted IS NULL AND n_auftrag_id=:contractId
ALSO not working.
Then I saw the new property and I typed in the keyfields which are specified as PK in database table. AND it worked!!!!
So where is the problem and when happens this and if you don't have a key will you update/delete sometimes all records from a table?
Thanks for your help!
Thomas
Here is the table definition
DROP TABLE IF EXISTS `p_cratemaker`.`t_transport_auftrag`;
CREATE TABLE `p_cratemaker`.`t_transport_auftrag` (
`n_auftrag_id` int(11) NOT NULL default '0',
`n_id` int(11) NOT NULL auto_increment,
`c_nr` varchar(25) NOT NULL default '',
`c_transporteur` varchar(50) NOT NULL default '',
`c_transporteur_strasse` varchar(40) default NULL,
`c_transporteur_strassenr` varchar(20) default NULL,
`c_transporteur_plz` varchar(15) default NULL,
`c_transporteur_ort` varchar(40) default NULL,
`c_transporteur_zu_haenden` varchar(40) default NULL,
`c_lade_firma` varchar(50) NOT NULL default '',
`c_lade_strasse` varchar(40) NOT NULL default '',
`c_lade_strassenr` varchar(20) NOT NULL default '',
`c_lade_plz` varchar(15) NOT NULL default '',
`c_lade_ort` varchar(40) NOT NULL default '',
`n_lade_staat_id` int(11) default NULL,
`c_lade_adr_zusatz_1` varchar(45) NOT NULL default '',
`d_lade_termin` date default '0000-00-00',
`c_lade_termin_prefix` varchar(10) default NULL,
`c_lade_zeit` varchar(15) default NULL,
`c_empf_firma` varchar(50) NOT NULL default '',
`c_empf_strasse` varchar(40) NOT NULL default '',
`c_empf_strassenr` varchar(20) NOT NULL default '',
`c_empf_plz` varchar(15) NOT NULL default '',
`c_empf_ort` varchar(40) NOT NULL default '',
`n_empf_staat_id` int(11) default NULL,
`c_empf_adr_zusatz_1` varchar(45) NOT NULL default '',
`d_empf_termin` date default '0000-00-00',
`c_empf_zeit` varchar(15) default NULL,
`c_empf_termin_prefix` varchar(10) default NULL,
`c_frachtzahler` varchar(50) NOT NULL default '',
`c_frankatur` varchar(20) default NULL,
`c_frachtvereinbarung` varchar(60) default NULL,
`m_bemerkung` text,
`d_created` datetime NOT NULL,
`d_gedruckt` datetime default NULL,
`n_user_id` int(11) NOT NULL default '0',
`d_deleted` datetime default NULL,
`c_transporteur_faxnr` varchar(20) NOT NULL default '',
`c_auftraggeber` varchar(40) NOT NULL default '',
`c_lade_ansprechpartner` varchar(40) default NULL,
`c_lade_telefon` varchar(20) default NULL,
`m_lade_bemerkung` text,
`n_einzelpreis` decimal(19,2) default NULL,
`n_waehrung_id` int(11) default '1' COMMENT 'kat_grp=25',
`n_aktiv` tinyint(1) NOT NULL default '1',
`c_empf_ansprechpartner` varchar(40) default NULL,
`c_empf_telefon` varchar(20) default NULL,
`m_empf_bemerkung` text,
`n_anzahl_rechnung` int(2) default '0',
`n_anzahl_nicht_verrechenbar` int(3) NOT NULL default '0',
`n_anzahl_auftragbestaet` int(3) NOT NULL default '0',
`n_anzahl_angeboten` int(3) NOT NULL default '0',
`n_transporteur_id` int(11) default NULL,
`n_ladestelle_id` int(11) default NULL,
`n_entladestelle_id` int(11) default NULL,
PRIMARY KEY (`n_auftrag_id`,`n_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Auftragposten von einem Auftrag';
