So, here's the story:
I am writting a VB6 program that accesses a MySQL server to get info and write info. I am using ADO to make the connections.
The program gets a recordset and calls a phone number from that recordset. If the caller answers, it sets the status of the call to accepted.
This program works mostly fine. The problem I need to run multiple instances of the program. When I try that, every instance of the program tries to call the first record at the same time. I need to find a way for the program to check if a record is already being accessed from another program. I can lock the write function, but how do I stop it from trying to read the record as well?
I saw a stored procedure for SQL on this site, but it doesn't work (or so it seems) for MySQL. I am open to doing it with ADO and VB6 or with MySQL stored procedures that I can access from VB6. Any ideas are welcome. Thanks.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Seems to me that the easiest way to control this would be for a store procedure to grab only a subset of data say 20 records and mark those records as in use. I would setup a separate column with a value of 0, then as the data is being processed by the store proc, change it to 1. The next instance would then not grab any rows that are marked 1.
Leon
Business Accounts
Answer for Membership
by: Raynard7Posted on 2007-07-24 at 17:02:31ID: 19561176
Hi,
What table types are you using? And what version of mysql?
Depending on these the stored procedures may / may not work and there may not be row level locking enabled.
However if you are using ado then you can execute sql strings directly so should be able to do anything you would do with a stored procedure if you are using the correct versions.
can you have one program (server side) that returns the next row, then you will nto get any contenion issues.