Re: RE : Cannot update or delete rows

Pascal Viandier wrote:
> Hi Luf,
>
>> -----Message d'origine-----
>> De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org]
>> De la part de Ludek Finstrle
>> Envoyé : July 31, 2006 00:05
>> À : Pascal Viandier
>> Cc : pgsql-odbc(at)postgresql(dot)org
>> Objet : Re: [ODBC] Cannot update or delete rows
>>
>>> I use PostgreSQL 8.1.4 and psqlodbc-08.01.0200.
>> I'm sorry but psqlodbc-08.01.XXXX doesn't support such feature
>> (updateable cursor). I know there is no info about it. But 08.01
>> uses libpq for communication with server and there are some
>> breakage in updateable code.
>>
>> Please try latest CVS from pgfoundry.org. It should do what you want.
>>
> I just tried the CVS release (psqlodbc-08.02.0002).
> It is a lot better: SQLSetPos() does not return the previous error for update or
> delete but it still does not work.
> The update returns:
> SQLSTATE: 07005
> NATIVE CODE: 15
> MESSAGE: update list null

Are you updating any columns of the row ?

> The delete returns:
> SQLSTATE: 42601
> NATIVE CODE: 7
> MESSAGE: syntax error at or near "where";

Please try the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue