Skip site navigation (1) Skip section navigation (2)

Re: Problem updating multiline varchar with VB6 and ODBC

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Guillaume Lelarge <guillaume(dot)lelarge(at)progimed(dot)fr>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problem updating multiline varchar with VB6 and ODBC
Date: 2002-07-23 01:24:25
Message-ID: 3D3CB049.D160D5BD@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-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/

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-07-23 08:51:27
Subject: Re: CX parameter of the connection string
Previous:From: Patrick HatcherDate: 2002-07-22 23:08:21
Subject: What is Cancel as FreeStmt?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group