Hi wie kann ich 2 Delete in einer
Query ausführen ohne 2 Excecute zu verwenden?
z.B.
Delphi-Quellcode:
QueryDelete.SQL.Text:='
Delete From `'+Tabelle.Customer+'
` Where Customer_number = :Customer_number';
// Positionen des Kunden loeschen
QueryDelete.SQL.Text:='
Delete From `'+Tabelle.Position+'
` Where Customer_number = :Customer_number';
QueryDelete.Params.ParamValues['
Customer_Number'] := CustomerInfos.customer_number;
QueryDelete.Execute;
//SQL-Statement ausführen
funktioniert ja leider nicht.