RE: Visual Basic and PostgreSQL ODBC
От | Carlos Felipe Zirbes |
---|---|
Тема | RE: Visual Basic and PostgreSQL ODBC |
Дата | |
Msg-id | 119A376B9565D511B65E0001022F6FDD023B06@TERRA обсуждение исходный текст |
Ответ на | Visual Basic and PostgreSQL ODBC ("Ryan C. Bonham" <Ryan@srfarms.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: