From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Row Level out of range on 07.02.0005 |
Date: | 2003-03-05 15:28:35 |
Message-ID: | 20030305152835.24555.qmail@web13804.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)yahoo(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Gamache | 2003-03-05 15:32:02 | Re: how to connect to a remote dbase using psql odbc |
Previous Message | Giuliano Gavazzi | 2003-03-05 15:05:18 | Re: Password not passed to ODBC from iODBC MacOSX |