RE: Visual Basic and PostgreSQL ODBC

Probably your recordset is a snapshot and not a dynamic recordset.
Strange thing is you get no errors in the delete operation.

Anyway, I think you shouldn't delete rows from tables this way.
Why don't you write a query a run through connection's execute command?

Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: carlosz@dbserver.com.br
Fone: (51) 3342-8055
Fax: (51) 3342-4838



-----Original Message-----
From: Ryan C. Bonham [mailto:Ryan@srfarms.com]
Sent: sexta-feira, 27 de julho de 2001 14:00
To: pgsql-odbc@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Visual Basic and PostgreSQL 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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html