Das sollte so funktionieren:
SQL-Code:
SELECT *
FROM Table_OrderTracking
WHERE Customer_Number like :i_edKNR
ORDER BY Order_Number
in Delphi...
Delphi-Quellcode:
With qrMain
Do
Begin
SQL.Text :=
'
SELECT *' + #10 +
'
FROM Table_OrderTracking' + #10 +
'
WHERE Customer_Number like :i_KNR' + #10 +
'
ORDER BY Order_Number';
// Parsen des Statements um Query Parameter zu finden...
Prepared := True;
// Werte an Query Parameter übergeben...
Parameters.ParamByName('
i_KNR').Value := edKNR.Text+'
%';
Open;
//...
End;