Re: "Invalid cursor position" error when using recordsetsand text fields

Brian Huber wrote:
> I'm using recordsets in VB to through psqlODBC
> 7.3.100 and am receiving "invalid cursor position"
> when trying to retrieve the value of text fields. I
> do not get this problem when retrieving numeric
> fields.

You don't say how you are accessing the tables, etc:

* DAO (version?)
* ADO (version?)
* Straight SQL (unlikely, given your problem)
* Something else...

Likely it is one of the first two (DAO or ADO). I can tell you that I
was experiencing that problem in a conversion of an application from
Access 97 to PG (using the ODBC drivers). At the time, my application
was using DAO, and I was running into all sorts of funky problems.
Switching to ADO solved the vast majority. If I had to do it all over
again, though - I think I would have gone for straight SQL updates.

Look through both the ODBC and GENERAL list archives - my posts and such
will be in there from earlier this year.

Andrew Ayers
Phoenix, Arizona

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.