I don't use rs.update simply because I find accessing the database with
conn.execute ("UPDATE table SET field=value;") yields more predictable results.
I'm also ONLY dealing with PostgreSQL, so I can optimize my SQL statements
specifically for PostgreSQL.
However, if I wanted to use rs.update I might try fiddling around with the
settings for "Use Declare/Fetch", and "UPDATABLE CURSORS". Couldn't hurt,
right?
CG
--- Muhammad Shariq Muzaffar <shariq77@yahoo.com> wrote:
> hi
> we are currently using pgsql 7.3.1 on Redhat linux
> 8.0, and we are developing interface using VB 6.0 on
> windows 2000/XP.
>
> We are having a problem using the latest psqlodbc i.e.
> ver 07.02.0005. When ever we try to update a record
> using '.update' command of the ADO recordset, ODBC
> gives us an error of 'ROW VALUE OUT OF RANGE' but when
> we use an older version of psqlodbc i.e. ver
> 07.01.0009, it runs smoothly.
>
> We are using dynamic type of recordsets. Is it an
> error, bug or do we have to install some other patch
> or something.
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
