HELP - Mailing list pgsql-odbc

From Sol M. Ferrer
Subject HELP
Date
Msg-id 001b01c2f4dc$c50644a0$f4e617d2@msc.net.ph
Whole thread Raw
List pgsql-odbc
 
I'm using VB 6 with the database postgreSQL, my problem is when i used movelast or moveprevious .. error popup and say's "The row set does not support fetching backwards". I attach my sample code.
 
Option Explicit
Dim WithEvents dbInvAct As ADODB.Connection
Dim rsChart As ADODB.Recordset
 
Private Sub Form_Load()
    Set dbInvAct = New ADODB.Connection
    dbInvAct.ConnectionString = "provider=msdasql.1; " & "data source=PostgreSQL; initial catalog=accounting;"
    dbInvAct.Properties("User Id").Value = "user"
    dbInvAct.Properties("Password").Value = "password"
    dbInvAct.Open
   
    Set rsChart = dbInvAct.Execute("Select * from Chart")
End Sub
 
Function Next()
    If rschart.EOF Or rschart.BOF Then
            MsgBox "Database Empty!", vbCritical
        Else
            rschart.MoveNext
            If rschart.EOF Then
                MsgBox "End of File Encountered!", vbExclamation
                rschart.MoveLast 
           End If
    End If
End Sub

pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: Insert fails from VB only when table is empty...?
Next
From: "Epperson, Wade"
Date:
Subject: FW: errors syncing postgresql with pocketpc database