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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-odbc by date

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

pgsql-general by date

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

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