Hi,
I'm running RC6 under RedHat9 and Windows 2000 with MySQL4 and the latest available JDBC driver from MySQL (and also using MySQL for the repository).
I've got some test tables and forms which use primary keys managed by MySQL via auto-increment.
In all cases, if I update a row's data through the mysql binary or MySQL Control Center, I can't get the change to be reflected in Servoy without switching to and back from Designer mode.
Relookup won't show the data changes, either when used from within the Select menu, or from controller.relookup(). New records added or old deleted are reflected when using relookup, but not data changes to existing records.
Is this the intended behavior? Any solutions to see changed data, if so?
Thanks for your time.