Search results

The error has happened again, on another record. Same place, different record, a few dozen records further on in the recordset. Unfortunately this is a live record, so we can't disable it...

It was always failing on the same record. There doesn't seem to be anything strange about that record, but then I'm not familar with PROGRESS databases and MERANT... We have now disabled that record, and are waiting for the error to happen again. This may take weeks!

I'm having an intermittent problem with one SQL query. Dim GetDN As DAO.Recordset sSQLStmt = "SELECT ..." Set GetDN = LeaseDB.OpenRecordset(sSQLStmt) If GetDN.BOF = False And GetDN.EOF = False Then GetDN.MoveFirst Do While Not GetDN.EOF <code...> GetDN.MoveNext '<-------- Error s1010 Function...