16-12-2024, Saat: 16:51
Herkese Selam,
Aşşağıda MSSQL e kayıt için iki yöntem var, bunlardan hangisini kullanmak daha mantıklı olacaktır, siz hangini tercih edersiniz nedeni ile.
uses dmUnit;
Birinci Yöntem;
*************************************************************
var
saveQry: TFDQuery;
begin
saveQry:= TFDQuery.Create(Nil);
saveQry.Connection := dmForm.fConn;
dmForm.fConn.StartTransaction;
try
saveQry.SQL.Add('Insert Into Personel(AD, SOYAD, YAS, BOLUM);
saveQry.SQL.Add('Values(:R0, :R1, :R2, :R3)';
saveQry.ParamByName('R0').Asstring := ADEDIT.Text;
saveQry.ParamByName('R1').Asstring := SOYADEDIT.Text;
saveQry.ParamByName('R2').Asstring := YASEDIT.Text;
saveQry.ParamByName('R3').Asstring := BOLUMEDIT.Text;
saveQry.ExecSQL;
FDConnection.Commit;
Except
on E: Exception do
begin
FDConnection.Rollback;
Showmesage(E.Message);
Result := False;
end;
end;
FreeAndNil(saveQry);
end;
İkinci Yöntem;
*************************************************************
begin
dmForm.fConn.StartTransaction;
try
dmForm.fConn.ExecSQL('Insert into Personel(AD, SOYAD, YAS, BOLUM) Values(:R0, :R1, :R2, :R3), [ADEDIT.Text, SOYADEDIT.Text, YASEDIT.Text, BOLUMEDIT.Text]);
dmForm.fConn.Commit;
Except
on E: Exception do
begin
dmForm.fConn.Rollback;
Showmesage(E.Message);
Result := False;
end;
end;
end;
Aşşağıda MSSQL e kayıt için iki yöntem var, bunlardan hangisini kullanmak daha mantıklı olacaktır, siz hangini tercih edersiniz nedeni ile.
uses dmUnit;
Birinci Yöntem;
*************************************************************
var
saveQry: TFDQuery;
begin
saveQry:= TFDQuery.Create(Nil);
saveQry.Connection := dmForm.fConn;
dmForm.fConn.StartTransaction;
try
saveQry.SQL.Add('Insert Into Personel(AD, SOYAD, YAS, BOLUM);
saveQry.SQL.Add('Values(:R0, :R1, :R2, :R3)';
saveQry.ParamByName('R0').Asstring := ADEDIT.Text;
saveQry.ParamByName('R1').Asstring := SOYADEDIT.Text;
saveQry.ParamByName('R2').Asstring := YASEDIT.Text;
saveQry.ParamByName('R3').Asstring := BOLUMEDIT.Text;
saveQry.ExecSQL;
FDConnection.Commit;
Except
on E: Exception do
begin
FDConnection.Rollback;
Showmesage(E.Message);
Result := False;
end;
end;
FreeAndNil(saveQry);
end;
İkinci Yöntem;
*************************************************************
begin
dmForm.fConn.StartTransaction;
try
dmForm.fConn.ExecSQL('Insert into Personel(AD, SOYAD, YAS, BOLUM) Values(:R0, :R1, :R2, :R3), [ADEDIT.Text, SOYADEDIT.Text, YASEDIT.Text, BOLUMEDIT.Text]);
dmForm.fConn.Commit;
Except
on E: Exception do
begin
dmForm.fConn.Rollback;
Showmesage(E.Message);
Result := False;
end;
end;
end;