Example:
1) USE MSSQL DATABASE;
2) SET A TSQLConnection on you form
3) Set a TSimpleDataset on you form and set a sql command text on SQLCommandText
4) Set The TSimpleDataset of PacketRecords=100
5) Runvar
ATd:TTransactionDESC;
begin
c.PacketRecords
if not sc.InTransaction then
begin
sc.StartTransaction(atd);<----Error Here!
try
c.ApplyUpdates(0);
sc.Commit(atd);
except
sc.Rollback(atd);
end;
end;
Question:
How I must use (PacketRecords=100) and (StartTransaction) No error??
1) USE MSSQL DATABASE;
2) SET A TSQLConnection on you form
3) Set a TSimpleDataset on you form and set a sql command text on SQLCommandText
4) Set The TSimpleDataset of PacketRecords=100
5) Runvar
ATd:TTransactionDESC;
begin
c.PacketRecords
if not sc.InTransaction then
begin
sc.StartTransaction(atd);<----Error Here!
try
c.ApplyUpdates(0);
sc.Commit(atd);
except
sc.Rollback(atd);
end;
end;
Question:
How I must use (PacketRecords=100) and (StartTransaction) No error??
StartTransaction 會出錯當使用PacketRecords=-1 時
StartTransaction 無出錯I Need PacketRecords=100 或 0 時 無出錯