Yea, the problem isn't your interface, it's your database. MySQL is really a flat file system with a SQL front end, so there's not a lot you can do there.. You might think about implementing postgreSQL as an alternative, which might be able to support the per-user record locking & report that back on query. I know that Oracle would do it without question, but that's definitely $$$ beyond.
__________________
I'm gonna be rich and famous, as soon I invent a device that lets you stab people in the face over the internet.
|