Re: Visual Basic and PostgreSQL ODBC

From: Ryan Ho <ryanho(at)pacific(dot)net(dot)sg>
To: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Visual Basic and PostgreSQL ODBC
Date: 2001-07-28 04:46:17
Message-ID: 3B624399.8A40E2C3@pacific.net.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

"Ryan C. Bonham" wrote:

> 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

Having done a fair bit of VB programming (in VB 6), it seems to me that
recordcount is simply unreliable, no matter which database or which ODBC driver
you use... plain and simple. I remember not using recordcount at all in my VB
programming, and since i haven't done VB for 6 months, I can scarcely remember
what I used in its place.

Ryan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mr. Shannon Aldinger 2001-07-28 05:32:23 Re: Visual Basic and PostgreSQL ODBC
Previous Message Justin Clift 2001-07-28 03:14:15 Re: PostgreSQL to Dia program

Browse pgsql-odbc by date

  From Date Subject
Next Message Mr. Shannon Aldinger 2001-07-28 05:32:23 Re: Visual Basic and PostgreSQL ODBC
Previous Message Hiroshi Inoue 2001-07-27 22:17:17 RE: A problem with the nextval('') function