FDQuery.SQL.Text :=
'CREATE TABLE Employees (' +
' ID INTEGER GENERATED BY DEFAULT AS IDENTITY,' +
' Name VARCHAR(50) NOT NULL,' +
' Rank VARCHAR(50) NOT NULL,' +
' Number INTEGER NOT NULL' +
')';
procedure TForm1.InsertEmployee(const AName, ARank: string);
var
NextNumber: Integer;
begin
try
FDQuery.SQL.Text :=
'SELECT COALESCE(MAX(Number), 0) + 1 AS NextNumber ' +
'FROM Employees ' +
'WHERE Rank = :Rank';
FDQuery.ParamByName('Rank').AsString := ARank;
FDQuery.Open;
NextNumber := FDQuery.FieldByName('NextNumber').AsInteger;
FDQuery.Close;
FDQuery.SQL.Text :=
'INSERT INTO Employees (Name, Rank, Number) ' +
'VALUES (:Name, :Rank, :Number)';
FDQuery.ParamByName('Name').AsString := AName;
FDQuery.ParamByName('Rank').AsString := ARank;
FDQuery.ParamByName('Number').AsInteger := NextNumber;
FDQuery.ExecSQL;
ShowMessage('تم إدراج السجل بنجاح!');
except
on E: Exception do
ShowMessage('حدث خطأ: ' + E.Message);
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
InsertEmployee(EditName.Text, EditRank.Text);
end;