Re: Problem updating multiline varchar with VB6 and ODBC

Guillaume Lelarge wrote:
>
> Hi everyone,
>
> My postgresql 7.1.3 server is installed on a linux system.
> I use a VB6 app to collect and update datas through ODBC. I use the last
> ODBC driver release (07_01_0010). I think the 07_02_0001 driver is for
> 7.2.x server, but correct me if I am wrong.

7.02.0001 is also available for 7.1 or earlier.

> This code works great... near every time.
> I have problems when one of the column's type is a varchar and when its
> value contains several lines. I can see in the log that the driver
> doesn't find the row to update.

> Does it have to do with LFCR translation?

Maybe.
Could you confirm the server side string (LF or CRLF) ?

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/