ODBC record sets and loops

HCL Domino Domino Forum
1

Dear all,I need to import about 120,000 records form a Oracle DB.

Currently I’m using this For loop and i get nor as -1

is it bcos of the data volumn. Can i use a Do Until? which one is the best way

thanks in advance

shana

nor= rs.NumRows

For i = 1 To nor

rs.CurrentRow = i

PNo = rs.getValue(“POLICYNO”)

PName = rs.getValue(“NAME”)

Set Idoc= New NotesDocument(db)

Idoc.Form =“BusinessPortfolio_Form”

Idoc.BP_PolicyNo=PNo

Idoc.BP_Name=PName

Call Idoc.save(True,True)

Next

2

Subject: ODBC record sets and loops

The NumRows of a resultset will return -1 when the entire result set hasn’t been cached - saying it doesn’t know how many records there are.

Your idea of a Do loop is a good one, as this is from the designer help:

Do

result.NextRow

'Process each row

Loop Until res.IsEndOfData

3

Subject: thanks a lot