Re: Visual Basic and PostgreSQL ODBC

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> "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
>

Two solutions use .EOF or .BOF on your recordset, or .MoveLast, get the
.RecordCount, then a .MoveFirst. If you don't do the .MoveLast the record
count tends to stay at it's last value or one. This should get you on the
right track, note I haven't tried this with postgresql as a backend, but
it's what you have to do with MS backends.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Made with pgp4pine 1.75

iEYEARECAAYFAjtiTnoACgkQwtU6L/A4vVBifQCgkMTbhLbhgPEbYQyrUGKg5Vfh
hP4An35rDduD2oNELy3jJZV4PSSFWOmK
=h0Vj
-----END PGP SIGNATURE-----