Hi,am using notesODBC classes to get data from a view in oracle.
the view has 11000 rows.
but my resultset has only 3597 rows. I am not able to go beyond that number.
any suggestions?
TIA
Anish
Hi,am using notesODBC classes to get data from a view in oracle.
the view has 11000 rows.
but my resultset has only 3597 rows. I am not able to go beyond that number.
any suggestions?
TIA
Anish
Subject: ODBC returns fewer rows
this is the first problem that most people encounter when using ODBC and lotusscript, if you do a search there are countless examples of how to work around the problem by looping until you reach an EOD (or something along those lines).
although they’re probably in the R5 forum.
Subject: RE: ODBC returns fewer rows
thanks for your response.the problem is that EOD occurs at around 3000 rows. the resultset does not contain the rest of the rows 8000.
have tried setting maxrows,fetchbatchsize etc.
I have retrieved more than that # of rows on past occassions.
but this one doesnt seem to work for me.
Subject: RE: ODBC returns fewer rows
try this code and see if it works, then minimise it.
have you set the CacheLimit to a low number, say 100?