Skip site navigation (1) Skip section navigation (2)

Bug #657: VB DAO MoveFirst/MoveLast become invalid operation

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #657: VB DAO MoveFirst/MoveLast become invalid operation
Date: 2002-05-06 06:00:59
Message-ID: 20020506060059.017A54758E3@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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


Responses

pgsql-bugs by date

Next:From: Hans PlumDate: 2002-05-06 16:50:14
Subject: Bug in functions lower(), upper() with SQL_ASCII and LATIN1?
Previous:From: smithDate: 2002-05-06 04:47:52
Subject: Use Postgresql in VB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group