Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Thread Tools Display Modes
Old 12-14-2010, 10:11 AM
Solaris Solaris is offline
Join Date: Mar 2008
Posts: 77
Question Show Records 10 by 10 ...

Dear Experts.

I have a table in MS-Access with large Records on LAN Network.

I made connection to it by AdoConnection and my RAD is Delphi7.

If try to Show All records at Once for user App, you know take several minutes.

I want to findout a way that show 10 by 10 records when user request it.

for example at first time show top 10 records, and when user click "Next" button, show another 10 records.

any solution available?
Reply With Quote
Old 12-14-2010, 10:36 AM
Norrit Norrit is offline
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,335

Don't know Access (I know, but never worked with it).

In MSSQL there's a method called ROW_NUMBER()
perhaps this is also available in Access...

Easiest to gain speed is to fetch only the columns you're showing... For example, in a grid you don't display columns of type VARCHAR(max)...
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

All times are GMT. The time now is 02:42 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.