Hello,
I have been spending the past couple days trying to understand how to implement row locking in MySQL for program we plan in porting from betrieve 6.12 and Random Access flat files in VB6.
Having read and scoured the net I have not found any significatant material to understand how to implement record locking short of implementing a custom solution(less desirable) I undertand that using MySQL with Innodb supports row locking.
I am hoping someone can provide some samples perhaps on how to select a record effectively locking it from other sessions and update/cancel the locked record using vb.net and the mysql.connector
Thank you everyone.
I have been spending the past couple days trying to understand how to implement row locking in MySQL for program we plan in porting from betrieve 6.12 and Random Access flat files in VB6.
Having read and scoured the net I have not found any significatant material to understand how to implement record locking short of implementing a custom solution(less desirable) I undertand that using MySQL with Innodb supports row locking.
I am hoping someone can provide some samples perhaps on how to select a record effectively locking it from other sessions and update/cancel the locked record using vb.net and the mysql.connector
Thank you everyone.
