Visual Basic and PostgreSQL ODBC

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Visual Basic and PostgreSQL ODBC
Date: 2001-07-27 16:59:36
Message-ID: 19AB8F9FA07FB0409732402B4817D75A038A1C@FILESERVER.SRF.srfarms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi,

Ok I have a problem, that I need to find a fix or workaround for. I have a
Visual Basic 6 application that calls on a PostgreSQL database. I have code
that calls a table and runs a loop on it, deleting recordsets until the
recordcount equals a certain number.. The code deletes the records fine, the
problem is the recordcount doesn't change.. Does anyone know what is going
on and how to fix it? Thank you

Ryan

VB CODE

rstRecord2.MoveFirst
Do Until rstRecord2.RecordCount = 0
rstRecord2.Delete
rstReocrd2.MoveNext
Debug.Print rstRecord2.RecordCount
Loop

Responses

Browse pgsql-general by date

  From Date Subject
Next Message martin.chantler 2001-07-27 17:15:30 Re: Visual Basic and PostgreSQL ODBC
Previous Message Patrick Welche 2001-07-27 15:51:52 Re: Question about Foreign key!

Browse pgsql-odbc by date

  From Date Subject
Next Message Gilles DAROLD 2001-07-27 18:53:16 OpenLDAP and PostgreSQL
Previous Message Ryan C. Bonham 2001-07-27 13:46:37 Error with DECIMAL or NUMERIC data type