Thanks Ralf, the problem is with my iPhone app which seems to add an empty record to table DH. Thanks for your help. Regards...Andrew Skylog Development In a message dated 03/09/2009 09:39:57 GMT Standard Time, delphi@xxxxxxxx writes: >No, I was using: > > DISQLite3UniDirQuery1.SelectSQL:= 'Select * FROM DH'; > DISQLite3UniDirQuery1.Active:= true; > recCount:= 0; > while not DISQLite3UniDirQuery1.EOF do begin > Inc(RecCount); > DISQLite3UniDirQuery1.Next; > end; I am not sure what you are doing differently than I do. My code is attached. I pleaced your database just next to the project's executable. The counts for table "DH" return 0 records with each approach taken.