Page 1 of 1

0 record(s) updated. Only one record should have been update

Posted: 10.12.2016, 08:53
by gelinp
Hi,

I'm using :
- zeoslib 7.2 with protocol mysql-5
- mysql server version 5.5.53-0+deb8u1 (Debian))

- Lazarus 1.6
- Linux debian.


I've got an error message : 0 record(s) updated. Only one record should have been update when I write a string into my Database with zeoslib. I find out that it is raised on Post after go to Edit state into a dataset. I'm testing and I can see the problem is when I write white characters at the end of a String dataset filed like this :

Code: Select all

MyDataset..Edit;
MyDataset.FieldByName('indice').AsString := 'This text cause the BUG because of white characters at the end     '; 
MyDataset.Post
If I add white characters at the begining of the string there is no problem, but at the end it's the error message.

Is it a new/old bug ? IS it a parameter to modify with the mysql database connector ?

Thank you for your help.
Patrick