SELECT #getQueryString()# WHERE salesClientUnitPaymentSchema.idSalesClientUnit= SELECT #getQueryString()# WHERE 1=1 AND salesClientUnit.idSalesClientState IN (,,) AND ( salesClient.nameFirst LIKE OR salesClient.nameFirst1 LIKE ) AND ( salesClient.nameLast LIKE OR salesClient.nameLast1 LIKE ) AND salesClientUnit.idProject= AND salesClientUnit.idEmployee= ORDER BY #arguments.orderBy##module.list.orderBy# DELETE FROM salesPayment WHERE idSalesClientUnit= AND amount=0 INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , , ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT IGNORE INTO salesPayment ( idSalesPaymentType, idSalesClientUnit, datePaymentExpected, amountExpected ) VALUES ( , , NULL, ) INSERT INTO salesClientUnitPaymentSchema ( idSalesClientUnit, idCurrency, booking, dateBooking, hook, dateHook, monthly, monthes, dateMonthlyPaymentStart, lastMonthlyPaymentDay, final1, final2, dateFinal1, dateFinal2, penalty, extra1, extra2, extra3, extra4, dateExtra1, dateExtra2, dateExtra3, dateExtra4 ) VALUES ( , , , NULL, , NULL, , , , , , , NULL, NULL, , , , , , NULL, NULL, NULL, NULL ) ON DUPLICATE KEY UPDATE idCurrency=, booking=, dateBooking=NULL, hook=, dateHook=NULL, monthly=, monthes=, dateMonthlyPaymentStart=, lastMonthlyPaymentDay=, final1=, final2=, dateFinal1=NULL, dateFinal2=NULL, penalty=, extra1=, extra2=, extra3=, extra4=, dateExtra1=NULL, dateExtra2=NULL, dateExtra3=NULL, dateExtra4=NULL Details: " & cfcatch.Detail> DELETE FROM salesClientUnitPaymentSchema WHERE salesClientUnitPaymentSchema.idSalesClientUnit= DELETE FROM salesPayment WHERE salesPayment.idSalesClientUnit= Details: " & cfcatch.Detail> #_idx#