SQL Abfrage Formulieren!

[Robert_G]

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;