Thread: newline in varchar causing funny behavior?

Hello All!

Using VB6 / ODBC.  When there's a varchar containing text and a CRLF, and
I  try to change that field - even if it's not a key, not indexed, and not
in any way interesting [other than containing a CRLF] - I get an error
about how "some of the fields have changed and the record can no longer be
located.

Any suggestions?

> Using VB6 / ODBC.  When there's a varchar containing text and a CRLF, and
> I  try to change that field - even if it's not a key, not indexed, and not
> in any way interesting [other than containing a CRLF] - I get an error
> about how "some of the fields have changed and the record can no longer be
> located.

What PgSQL, psqlodbc version are you using? Are you using ANSI or UNICODE
psqlODBC? What OS?
You wrote too few informations.

Regards,

Luf

Johann wrote:
> Hello All!
>
> Using VB6 / ODBC.  When there's a varchar containing text and a CRLF,
> and I  try to change that field - even if it's not a key, not indexed,
> and not in any way interesting [other than containing a CRLF] - I get an
> error about how "some of the fields have changed and the record can no
> longer be located.
>
> Any suggestions?

Please try to turn off the *LF<->CR/LF conversion* option.

regards,
Hiroshi Inoue