Re: Paging Query result in the DbGrid

From: "Vitali Kalinin" <vitkalinin@xxxxxxxxx>
Date: Thu, 25 May 2006 19:41:16 +0300

"IGLC" <rightwayonline@xxxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:4475d001@xxxxxxxxxxxxxxxxxxxxxxxxx

I have a large table in sql server
and the the ADO query result alaways get the Time Out message
any way to let the grid showing the data by limet and get the next page
automaticlly

many thankx

I see these options:
1. Redesign yours app to not show that much data
2. Switch do serverside cursors (see TCustomADODataSet.CursorLocation in
help)
3. Use asynch fetching (see TCustomADODataSet.ExecuteOptions in help)

.

References:
- Paging Query result in the DbGrid
  - From: IGLC

Prev by Date: Paging Query result in the DbGrid
Next by Date: Re: Database filed definition update - how?
Previous by thread: Paging Query result in the DbGrid
Next by thread: Runtime adding files to database via a TADOConnection - how?
Index(es):
- Date
- Thread