Hello Rekan-rekan Delphindo,
Saya mau tanya tentang koneksi ADOConnection.
Saya mencoba melakukan transaction di 2 database,
kalo dengan Access tidak terjadi locking,
kalo dengan SQL Server terjadi locking.
Potongan program kira-kira seperti berikut :
---------------
procedure TForm1.Button1Click(Sender: TObject);
begin
ADOConnection.BeginTrans
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
tbCustomer.Active:=True;
tbCustomer.Append;
tbCustomer.FieldByName('no_Cust').AsString:='A001';
tbCustomer.Post;
tbCustomer.Edit;
end;
procedure TForm1.Button3Click(Sender: TObject);
begin
ADOConnection.CommitTrans;
end;
------------------
Locking terjadi pada saat button2 kita click.
(jika kita melakukan proses SELECT)
Saya udah coba mainkan di Locking type, keyset, dsb
ga bisa.
TIA
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
