Information générale
Catégorie:
Contrôles ActiveX
Titre:
DATAGRID and parametrized select
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement