I have a strange problem. My app uses SQL to insert a bunch of records in a MySQL table. I then use a TZTable to look at these records. On my local system the records show up fine. However when connecting to a remote customer's MySQL database the records do not show up (RecordCount=0). Even running the MySQL admin does not show these records. However, the customer seems to see them from his MySQL admin software. Any ideas as to what's wrong here?
Note this used to happen to me too. Then I added a .Refresh call. After that the records showed up in the TZTable. However even with the Refresh call the records are not seen when using the customer's database.
MySQL: Cannot see inserted records in TZTable
Moderators: gto, cipto_kh, EgonHugeist