I have a postgres table with a notes field defined as varchar(999) on pg
and cstring(1000) in clarion.
I update using a std form and a text box.
Now comes the weird bit
Sometime I get an Changed by another station error trying to update.
I've traced this back to the Postgres field having the last CR LF
truncated to LF.
So 2 lines at the end look like CR LF LF, but Clarion still sees this as
CR LF CR LF !! ie the field is 1 character different. It's only the
last Character that this happens on.
Meaning the update which tries to update where everything matches, fails.
Anyone seen anything like this before?
I'm sort of lost