bug?

From: Antoine <melser(dot)anton(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: bug?
Date: 2006-06-12 14:02:55
Message-ID: 92d3a4950606120702i129aadb4xa1807d090bb3cb21@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
Just came across an *extremely* annoying problem, which I suspect is a bug.
In any case, we had the following problem - a row could be selected
with an optimistic lock,
my_recordset.Open my_query, myconnection, adOpenDynamic,
adLockOptimistic, adCmdText
We have set Use declare/fetch set. I can modify the values in the
recordset, however, when I attempt to my_recordset.update, I get the
message:
Query-based update failed because the row to update could not be found
(or something very similar).
I realised what was causing the problem, there was some porridge in a
varchar(14) column, which was being reported as being
len(my_recordset!my_column)=15 in VB6 (select char_length(my_column)
from my_table was returning 14)!
Setting it to null (via direct query) enabled my to update the field
in the normal manner after that.
I was asking myself whether there might be something to do with the
fact that I haven't specified an encoding (just used the default i
guess) though I couldn't immediately see how to do this - the db has
latin9 encoding... I couldn't see anything in mylog though...
Is this a bug or an error in our setup somewhere?
Cheers
Antoine

from psqlodbc_1348.log

DSN info: DSN='my_database',server='192.168.1.1',port='5432',dbase='my_database',user='my_user',passwd='xxxxx'
onlyread='0',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

--
This is where I should put some witty comment.

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2006-06-12 15:25:42 Re: psqlodbc - psqlodbc: The version is now 8.2.0005.
Previous Message Ludek Finstrle 2006-06-12 08:44:16 Re: 8.02.00.02 driver incompatibilities