Re: Problem updating multiline varchar with VB6 and ODBC

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Problem updating multiline varchar with VB6 and ODBC
Дата
Msg-id 3D3CB049.D160D5BD@tpf.co.jp
обсуждение исходный текст
Ответ на Problem updating multiline varchar with VB6 and ODBC  (Guillaume Lelarge <guillaume.lelarge@progimed.fr>)
Список 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/

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Patrick Hatcher"
Дата:
Сообщение: What is Cancel as FreeStmt?
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: CX parameter of the connection string