ODBC Query Not Returning All the Data in Result Set

HCL Domino Domino Forum
1

Hi All. I wrote an agent to creat a notes document with Oracle data.

i wrote the qry as Select * from table name.

There is approx 7500 rows in Oracle Table,

but in my result set it is returning only 1284 rows, i cheked it with result.lastrow,

how can i get all the 7500 rows in ResultSet?

Thanks & Regards.

Shariq.

2

Subject: ODBC Query Not Returning All the Data in Result Set

I think I’ve answered this question before…!:slight_smile:

A possible reason for this behaviour is that the amount of data is quite large, and therefore the ODBC call will timeout and return only those records that was fetched within the time limit.

Last time I delt with this issue I found that it could be worked around by moving the cursor to the end of the resultset and then back again:

ODBCRS.MoveLast

ODBCRS.MoveFirst

and then looping through the recordset in normal way…

There might be a timeout property that could be set somewhere, but I haven’t looked into that…

hth