George (george(at)lota(dot)net) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
VB DAO MoveFirst/MoveLast become invalid operation
Long Description
The VB program gets DAO RecordSet from a query to Postgresql. When it uses MoveFirst or MoveLast to move the cursor, error occurs with description "Invalid Operation". Is the new version not supporting these method in VB?
Sample Code
Set ws1 = DBEngine.CreateWorkspace("WorkSpace", "Admin", "", dbUseODBC)
Set dbConn1 = ws1.OpenConnection(DB1, False, False, connstr1)
Set res = dbConn1.OpenRecordset(txtSQL.Text, dbOpenDynaset)
res.MoveFirst
No file was uploaded with this report