 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Xie Bingpeng
Guest
|
 Posted: Mon Dec 08, 2003 12:02 pm Post subject: TADOTable RecNo problem |
 |
|
hi all:
Delphi 7, Access2000 for test.
I found if ADOTable1.TableDirect =True and
ADOTable1.CursorLocation=clUseServer,
its RecNo is not correct sometimes. for example:
ADOTable1 has 66 records.following code show 1-60 RecNo correctly, But
when RecNo=60,ADOTable1.Next should make RecNo=61, but now it becames 9!
ADOTable1.First;
while not ADOTable1.eof do
begin
ShowMessage(IntToStr(ADOTable1.RecNo));
ADOTable1.Next;
end;
is this a ADO bug?
|
|
| Back to top |
|
 |
baloonatic@hotmail.com
Guest
|
| Posted: Tue Dec 09, 2003 6:59 pm Post subject: Re: TADOTable RecNo problem |
|
|
Personally I'd engineer out the use of recno, you can't count on it
being correct with any server side DBMS. If you have to 'remember' a
record use bookmarks.
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
