SQL query result incomplete

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: SQL query result incomplete

Feedback Type: Problem

Product Area: Domino Server

Technical Area: Application Development

Platform: Windows

Release: 8.5.3

Reproducible: Always

Dear all,

In a self written script I am accessing a SQL database to read data from a table and store them in Lotus documents. The access itself is okay so far as I am receiving data successfully BUT:

The result set is incomplete. According to the set conditions, I should receive about 2700 documents from the SQL server but I just receive the first 1542.

If I try to read the SQL table without any conditions as a test, I also just receive the first 1542 documents from the SQL table.

If I force to read 2000 lines from the SQL table ("For rows = 1 To 2000" instead of "For rows = 1 To result.NumRows"), it will give the first 1542 lines correctly and then the last value will be repeated again and again up to 2000.

I don't have any more idea. Any help will be appreciated, thank you.

Code:

result.FirstRow
result.LastRow
rows=result.NumRows

For rows = 1 To result.NumRows

result.CurrentRow = rows
uuu = result.GetValue("SQL FIELD NAME")
Set doc = db.CreateDocument
doc.Form = "NOTES_FORM"
doc.Notes_Field_Name = uuu
doc.Save True, True, True

Next

view.refresh

Feedback number WEBB98ECJE created by ~John Desfooplopoden on 06/06/2013

Status: Open
Comments:

Return to top

Printer-friendly

Search this forum

Member Tools

RSS Feeds

RSS feeds

	All forum posts RSS
	All main topics RSS