Dear Boris,
We've tentatively found a fix. Don't know if its a permanent fix.
What we did was on the table with the problem, we moved the primary key which is an integer type to a new column and replaced the original column with a character type field.
I'll post the codes once back in office.
Thanks
Yau