TADOTable raise Error code 3052 while post
From: Xie Bingpeng (xbp_at_teabird.com.cn)
Date: 04/29/04
- Next message: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Previous message: AlirezA: "Re: Connect to MSAccess database through internet"
- Next in thread: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Reply: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 29 Apr 2004 14:21:13 +0800
hi all:
Delphi7, win2k
I using following code for test:
AdoTable1 has 12000 records.
AdoTable1.First;
while not AdoTable1.eof do
begin
AdoTable1.Edit;
AdoTable1.Fields[2].AsFloat:=0;
AdoTable1.Post;
AdoTable1.Next;
end;
when update to 9000 records, AdoTable1.Post will raise error:
number of rows with pending changes exceeded the limit(when
Locktype=ltBatchOptimistic)
or
error 3052 (when Locktype=ltOptimistic)
does access has limit?
how to avoid this error?
thanks
- Next message: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Previous message: AlirezA: "Re: Connect to MSAccess database through internet"
- Next in thread: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Reply: George Christoforakis: "Re: TADOTable raise Error code 3052 while post"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]