HI,
I need to display 35K rows of 75 fields each for validation process to a user. My backend is Oracle and I access it through ADO. Everithing is fine but when I load my form, it takes 1-2 mins to show up and when the user is scrolling the datagrid, it takes 5 secs before it scrolls. I do know that the problem is related to the 35K rows I am loading so I tried to limit the number of rows.

I issue "SELECT * FROM MyOracleTable WHERE ROWNUM < 100" and it retreives me the first 99 rows. When I want to issue this through a command object, I send two parameters in order to have a sql string like this :
"SELECT * FROM MyOracleTable WHERE ROWNUM >firstparameter and < secondparameter"

However, I get an error message from the grid when I want to set Mygrid.datasource = MyRst telling me that the cursor is not bookmarkable.

Do I need to use another ActiveX control or is there something I should change in my logic ?

Thank you for your help,
Christian Cote