Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
pgsql-bugs@postgresql.org
Date:
George (george@lota.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,
erroroccurs 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

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

From
Hiroshi Inoue
Date:
pgsql-bugs@postgresql.org wrote:
>
> George (george@lota.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?

Please try the snapshot dll at http://w2422.nsk.ne.jp/~inoue/.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/