Wasn't sure where to post this ...
Our internal Customer system is a view-based application in VPME9.0, and one of our programmers, Paul, is modifying it to work with MySQL, to eventually tie in with our on-line ordering system for customers.
I have never used MySQL and being only 18 months from retirement it is like the nether regions of hell - I don't want to go there!
We have a situation where at least two members of staff have to be able to view the same customer record, and this causes a hang and eventual crash, we presume because of a record-locking issue in ODBC/MySQL.
Has anybody any experience in this area, sample code, links to on-line documentation, anything that can help us investigate this further?
Many thanks - Stephen