Обсуждение: 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