Since you are limiting the number of rows your user can see, I would recommend using a query to get the data and then refresh the grid when the user clicks the "More" button. Some databases have a built in SQL command to do this.
IMO, users don't process large blocks of data well, so it makes more sense to filter the data to a range of dates or codes or something which naturally limits the number of records returned. To arbitrarily stop at a given number does not help a user in doing his work and may end up frustrating him if the set of data is over 100 but not far over (like 101 records or something). Tom Nesler Live long!... Code Well!... and Prosper!... V -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rodney Veilleux Sent: Tuesday, June 26, 2007 12:11 AM To: [email protected] Subject: [delphi-en] Limiting DBGrid rows Hello Guru's Delphi 2005 - BDE I'm working with very large tables and I want to give users only100 rows (for example) to view in the DBGrid. DBTable Ranges functionality is not the answer because I simple want the first 100 rows. Is there a simple shortcut method to access/modify the protected VisibleRowCount property? Or is there another creative way without creating a new component? Thanks, Rodney ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links
