Could anyone help me on this ?
There are 1000s & 1000s of data on the Oracle database. Iam using a VB frontend to display them, but it is very very slow since the no. of records is huge
I need to do a kind of Paging. The query should bring only 100 records at a time. If I click the "Next page" button, the query should go to the database again and bring the next 100 records. Any help ?
I tried the Paging properties of the ADO object , but the delay is the same. It brings all the records at the first time, but this is NOT what I want
Thanks so much in advance
Enter your message below
Sign in or Join us (it's free).