Changed by another station bug?


#1

Hi All

I think I have a bug, but I’m not sure
Using SQL, in this case postgres 9.5

Really simple table for email templates. NO timestamps
wizarded up browse form

Can’t change anything. eg If I add 1 char to a subject and save it
comes up with ‘Changed by another station’

Could someone else look at this and let me know if I’m mad or not.

App, dct, sql included
app uses testdb DSN - set in init in frame

Sean Htest_sh1.zip (98.0 KB)


#2

SOLVED!
Just in case I did an SQL update and did a btrim() on all the string type fields.

Oddly after that it all works!

Strange


#3

Hi Sean,

But does the same database and code work in Clarion 10 without the btrim etc?
ie has the behaviour of the ODBC driver changed?

Graham


#4

Hi Graham
No. Same behaviour in both.
I think it may have been a conversion (from dat) issue


#5

Sean,

I too at times have struggled with the error using Clarion & Postgres.

In addition to problems with timestamps in keys, one gets the error when a dct has a string instead of a cstring defined for a Postgres varchar. These are the first 2 problems I check when the error arises. After verifying the field types, I also do a complete regenerate/recompile to insure that all tables are defined the same in every dll. While not so frequent, this has indeed solved the problem a couple of times.

Recently, I spent some significant time attempting to track a change that brought the error on a form procedure which previously had been fine. Unfortunately, I was not successful at finding the exact change but did solve the issue by specifying WATCH in the dct for every updateable table field on the form.

To know exactly why adding the attribute made the difference for this specific table MIGHT give a clue as to why the error unexpectedly arises for table fields without it.