hi
I have a complex MS Access database with several related tables. In
the database there is a complex query, that uses other complex
queries and that returns 348 records when run with qbe. When the
query is run in QBE there is a slight delay before all 348 records
appear.
I writen a simple delphi app with an adoConnection component and
initially an adotable component. The connection component connects
to the database and the adotable component shows a list of available
tables and queries. However when I choose the access query that
normally returns 348 reocrds (in access) my delphi app only shows
51!!??
I have tried looking at the recordsetstate to see if it is
stFetching, but it comes back stOpen.
Changing values for cachesize and maxrecords from default to 400
didn't make any difference.
I tried using other ADO components such as the ADOQuery and
ADODataset.
They all retrieve only 51 records.
I also tried using a record set in code linked to an MS Access form,
again the recordset only got 51 records.
Double checking the query in qbe always returns 348.
Can anyone suggest what is happening?
Many thanks
Pete
These are my components:
ADOConnection1: TADOConnection
Connected = True
ConnectionString =
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Study-2
\SharedDoc' +
's\Admin\Database\Copy of Datab' +
'ase.mdb;Persist Security Info=False'
LoginPrompt = False
Mode = cmShareDenyNone
Provider = 'Microsoft.Jet.OLEDB.4.0'
Left = 108
Top = 60
end
object query1: TADOTable
Active = True
CacheSize = 100
Connection = ADOConnection1
CursorType = ctStatic
TableName = 'QryMassICTDist5'
Left = 184
Top = 80
end
object query: TADODataSet
CacheSize = 400
Connection = ADOConnection1
CursorType = ctStatic
MaxRecords = 400
OnFetchProgress = queryFetchProgress
CommandText = 'select * from QryMassICTDist5'
Parameters = <>
Prepared = True
Left = 144
Top = 80
end
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
