SQLQuery das Feld 'id' wurde nicht gefunden.

[Dr. Jack]

Code:

SQLQuery1.SQL.Add('SELECT last_insert_rowid() as id FROM users');
    SQLQuery1.open;
        if not sqlquery1.IsEmpty then
    begin
      ID := SQLQuery1.FieldByName('id').AsInteger;
    end;
    SQLQuery1.Close;

ich habs so:

Code:

main.qryproducts.SQL.Clear;
main.qryproducts.Params.Clear;
main.qryproducts.SQL.text:='SELECT ID FROM fam_check WHERE ID = (SELECT MAX(ID) FROM fam_check)';
main.qryproducts.open;
id:=  main.qryproducts.FieldByName('id').AsString;