ODBC 8.02 v 8.5

running the same code (attached below) on an 8.02 (Win XP) client and 8.5(Win Vista) client. when i get to the end, on the 8.02 client, the value is True and it continues while on the 8.5 client, the value is False and it stops.

Sub Initialize

bom$="bom"

hrs$="hours"



Dim session As New Notessession

Dim db As Notesdatabase

Set db = session.currentdatabase



Dim view As notesview

Set view=db.getview("byForm")

Dim coll As notesdocumentcollection

Set coll=view.getalldocumentsbykey("StdCost")

’ Call coll.RemoveAll(True)

Dim con_stdcost As New odbcconnection

Dim qry As New odbcquery

Dim res_stdcost As New odbcresultset

Dim res_prtinfo As New odbcresultset

Call con_stdcost.connectto(hrs$)

Set qry.connection=con_stdcost

qry.sql = "select * from qryLotusNotesLookup"

Set res_stdcost.query=qry

res_stdcost.execute

retcode% = res_stdcost.FirstRow