Strange problem

From: jason (jason_at_no-replies.com)
Date: 07/13/04 

Date: 13 Jul 2004 06:23:55 -0700

Hi,
I am using Delphi 6 Enterprise (with the latest updates).
I am connected via a TADOTable to an access database table.
My table has approx. 150 records in it, with an autoincrementing
id-field, called ArchiveID as the primary key.

When I execute the following code:

if tblArchive.Active = false then
  tblArchive.Open;
tblArchive.Last;

showmessage(tblArchive.fieldbyname('ArchiveID').asstring);

Now instead of getting a message showing '150' I am getting a message showing '94'. I checked in my table and I have sequencial records from 1 to 150.

Why when I call the last procedure does it not position itself on the last record in the table, in my case the record with an ArchiveID=150??

Many thanks for you help

Relevant Pages

  • Re: Printer Problem and "Support" for RH Enterprise WS Release 9 (Shrike)
    ... thing as RH Enterprise WS Release 9. ... All the updates are available here; ... site listed above and download all the updates for use when needed, ... -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." ...
    (linux.redhat.misc)
  • Re: Uploading changes to Project Server
    ... etc. Add resources to the project using Tools - Build Team from Enterprise, ... updates from team members and process the updates into the project plan, ... Enterprise Project Trainer/Consultant ... "We wrote the book on Project Server" ...
    (microsoft.public.project)
  • Re: Inconsistent Performance of Insert
    ... > normally the log file updates in the 1000+ per second ... > record name (FID) and a record value. ... This table has approx. ... FROM A LEFT JOIN AV AS ZZTEMPA ON A.RID ...
    (microsoft.public.sqlserver.server)
  • Re: Which distro for workstations?
    ... package updates in Testing, of which approx 1,000 ... applied to a typical workstation here. ... During the same period there were approx 800 package ... Debian GNU/Linux Consultant ...
    (Debian-User)
  • Enterprise server - critical updates
    ... I have recently upgraded to Windows Enterprise Server ... Several updates specifically mention ...
    (microsoft.public.windowsupdate)