Mehrere Suchbegriffe in einem Datensatz suchen

[Flo]

Also jetzt kommt ungültiges Schlüsselwort in Zeile 2 (select)

Code:

Delphi-Quellcode:

WITH Query1 DO
    BEGIN
        Close;
        WITH SQL DO
          BEGIN
            Clear;
          Add('SELECT * ');
Add('SELECT * FROM kosten.db wHERE abteilung = "' + Edit1.Text + '"'
+ ' AND reihe = "' +edit2.Text+'"'
+ ' AND nummer <= ' + edit3.text);
          END;
        Query1.Active := True;
        Open;
      END;;