Display data in pages
-
Hi everyone, I have a CDaoDatabase connection, I open a CDaoRecordset with this. The problem is: I have more of 30000 records stored in tables. How to get portion of this data.? for example: query1 : first 1000 records query2 : next 1000 records (1001 to 2000) query# :... I'm using the RDBMS MSDE2000. The statement "select TOP ..." only retrieve the first records. Thanks in advance. Ivan Cachicatari www.latindevelopers.com
-
Hi everyone, I have a CDaoDatabase connection, I open a CDaoRecordset with this. The problem is: I have more of 30000 records stored in tables. How to get portion of this data.? for example: query1 : first 1000 records query2 : next 1000 records (1001 to 2000) query# :... I'm using the RDBMS MSDE2000. The statement "select TOP ..." only retrieve the first records. Thanks in advance. Ivan Cachicatari www.latindevelopers.com
here's one way: 1. create a temp table with all the fields in your recordset and an identity int column. 2. put all the results from your query into that table (INSERT INTO...) 3. SELECT from that temp table WHERE ID BETWEEN 1001 AND 2000 or, if your original recordset has an identity column, you can just use that. Cleek | Image Toolkits | Thumbnail maker
-
here's one way: 1. create a temp table with all the fields in your recordset and an identity int column. 2. put all the results from your query into that table (INSERT INTO...) 3. SELECT from that temp table WHERE ID BETWEEN 1001 AND 2000 or, if your original recordset has an identity column, you can just use that. Cleek | Image Toolkits | Thumbnail maker
Thanks for you post. This option downs the performance of the database server. I have a Pentium III 550Mhz on Win98 and MSDE2000 as data server. You Known another method to do this. Ivan Cachicatari www.latindevelopers.com
-
Thanks for you post. This option downs the performance of the database server. I have a Pentium III 550Mhz on Win98 and MSDE2000 as data server. You Known another method to do this. Ivan Cachicatari www.latindevelopers.com
Ivan Cachicatari wrote: You Known another method to do this sorry, i don't. i don't know of any Microsoft SQL iimplementations that allow it, but with MySQL you can use "SELECT * FROM whatever LIMIT low,high". with SQLServer and Access, i've always had to use the temp table+identitiy field trick Cleek | Image Toolkits | Thumbnail maker