Board index » delphi » Not seeing all records

Jon Scott

Delphi Developer
Sun, 15 Dec 2002 03:00:00 GMT

Not seeing all records

Using Delphi 5 and TADOTable on a MS Access table.

I'm not too experienced in using ADO or Access tables, so here goes:

My Delphi app populated a table with 983 records.  I can see all 983 records in Microsoft
Access, however, I can't see all the records in Delphi (TDBGrid).  I'm only showing 970, and
doing a RecordCount shows only 970 records.  I just don't see why these additional 13 records
aren't shown in Delphi.  What's the deal?

Jon.

 
Michael Rodrigue

Delphi Developer
Sun, 15 Dec 2002 03:00:00 GMT

Re:Not seeing all records


Are there any unique indexes/filters on the table?  If you close and re-open
the table, do the records show up then?

--
Michael Rodriguez
Compeat Restaurant Systems
m...@compeat.com

Quote
"Jon Scott" <jsc...@landstar.com> wrote in message

news:8jdgk9$lm14@bornews.borland.com...
Quote
> Using Delphi 5 and TADOTable on a MS Access table.

> I'm not too experienced in using ADO or Access tables, so here goes:

> My Delphi app populated a table with 983 records.  I can see all 983

records in Microsoft
Quote
> Access, however, I can't see all the records in Delphi (TDBGrid).  I'm

only showing 970, and
Quote
> doing a RecordCount shows only 970 records.  I just don't see why these

additional 13 records
Quote
> aren't shown in Delphi.  What's the deal?

> Jon.

Vassil Nazaro

Delphi Developer
Mon, 16 Dec 2002 03:00:00 GMT

Re:Not seeing all records


There was such a bug with ADO and server cursors I can recall.
If scrolling the grid to the last record and then back to the 1st
the lost records should appear. This problem doesn't occur with
client cursors. I don't remember whether this was a problem with
TADOTable only or with ADO in general. Try the TADODataSet.

HTH
--
V. Nazarov
IT Manager, Sofia Cable

Quote
"Jon Scott" <jsc...@landstar.com> wrote in message

news:8jdgk9$lm14@bornews.borland.com...
Quote
> Using Delphi 5 and TADOTable on a MS Access table.

> I'm not too experienced in using ADO or Access tables, so here goes:

> My Delphi app populated a table with 983 records.  I can see all 983 records
in Microsoft
> Access, however, I can't see all the records in Delphi (TDBGrid).  I'm only
showing 970, and
> doing a RecordCount shows only 970 records.  I just don't see why these

additional 13 records
Quote
> aren't shown in Delphi.  What's the deal?

> Jon.

Jon Scot

Delphi Developer
Mon, 16 Dec 2002 03:00:00 GMT

Re:Not seeing all records


Actually, I found the problem had to do with my TADOCommand.Execute method.  I now use
TADOConnection.Execute and the problem went away.

Jon.

Quote
"Jon Scott" <jsc...@landstar.com> wrote in message news:8jdgk9$lm14@bornews.borland.com...
> Using Delphi 5 and TADOTable on a MS Access table.

> I'm not too experienced in using ADO or Access tables, so here goes:

> My Delphi app populated a table with 983 records.  I can see all 983 records in Microsoft
> Access, however, I can't see all the records in Delphi (TDBGrid).  I'm only showing 970, and
> doing a RecordCount shows only 970 records.  I just don't see why these additional 13 records
> aren't shown in Delphi.  What's the deal?

> Jon.

José Carlos da Silv

Delphi Developer
Mon, 16 Dec 2002 03:00:00 GMT

Re:Not seeing all records


Take a look in the follow text obtained from :
http://www.inprise.com/devsupport/delphi/fixes/delphi501/database.htm...

"Problem:

When a DBGrid is connected to a ado dataset with
the cursorlocation set to clUseServer, all records
end up being fetched up front by the call to
RecordCount.

Workaround:

Use client side cursor or
Turn off the vertical scrollbar in the grid."

--
-----------------------------------------------------
Click here for Free Video!!
http://www.gohip.com/freevideo/

Jon Scott <jsc...@landstar.com> escreveu nas notcias de
mensagem:8jdgk9$l...@bornews.borland.com...

Quote
> Using Delphi 5 and TADOTable on a MS Access table.

> I'm not too experienced in using ADO or Access tables, so here goes:

> My Delphi app populated a table with 983 records.  I can see all 983

records in Microsoft
Quote
> Access, however, I can't see all the records in Delphi (TDBGrid).  I'm

only showing 970, and
Quote
> doing a RecordCount shows only 970 records.  I just don't see why these

additional 13 records
Quote
> aren't shown in Delphi.  What's the deal?

> Jon.

Other Threads

1. Paradox record posted not seen by 2nd workstation

2. Record updates not seen on 2 machines

3. Inserted record no being seen

4. Seeing new inserted records in updateable TQuery objects

5. The last record can't been seen - Paradox 7.0

6. Seeing deleted DBase records in Delphi

7. Commitd Records Seen by Others

8. Application.ComponentCount not seeing my forms, why?

9. Problem using MAPI (EMail attachments are not seen by recepient using Eudora)

10. Shift+Del Keys Not Being 'Seen'