1 2 3 4 5 6 7 8 9 10 11 12 13
| strquery := 'insert into PROCESS_LABO_MP_TARRIVEE '
+'( date, heure, datefab, Numlot, Residu, Qterecep, Id_CTRLMP , Id_MAGACUVE, Operateur) '
+'values '
+'( ' + datetostr(self.datepickerRech.Date) + ', '
+ FormatDateTime('HH:NN', self.timepickerReception.Time) + ''', '
+ datetostr(self.datepickerFab.Date) + ', '
+ '''' + self.zsNumlot.Text + ''', '
+ self.zsIdResidu.Text + ', '
+ self.zsQte.Text + ', '
+ self.zsIdCtrlMp.Text + ', '
+ self.zsIdMaga.Text + ', '
+ '''' + self.zsOperatr.Text + ''')';
_frmData.prRequete(self.cdsInsert, self.sqlInsert, strQuery, 'e'); |
Partager