HELP

From: "Sol M(dot) Ferrer" <smangubat(at)msc(dot)edu(dot)ph>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: HELP
Date: 2003-03-28 03:47:34
Message-ID: 001b01c2f4dc$c50644a0$f4e617d2@msc.net.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Epperson, Wade 2003-03-28 20:36:26 FW: errors syncing postgresql with pocketpc database
Previous Message Booth, Robert 2003-03-27 23:14:23 Access problems