Hello,
I am developing a telephony app which updates a database based
on the call progress. I am running the same .EXE on 2 different phone
lines by passing the phone line in the command line. Anyway, I am
having trouble writting to the same database and the result is the
error 3265 "Item not found in collection" and followed by 3186
"Couldn't save; currently locked...". I use SQL to gather the database
search,
'search new outbound calls
rstable = db.openrecordset("select * from table where call = 'NEW')
Next,
rstable.edit
rstable!fields = "whatever"
rstable!update
'search busy outbound calls
rstable = db.openrs("select * from table where call = 'BUSY')
rstable.edit
rstable!fields = "whatever"
rstable!update
Keep in mind, I am running 2 seperate instances of this app. How can I
edit/update a record (1 at a time) and keep the other instance
"on hold" until the record is updated from the "first" instance?
I think lockedits and editmode are 2 methods I should look into, but
is there a better way? I am trying to stay away from centralizing the
database, and just running 2 instances of the same app. Any
suggestions as to how to rectify my problem?
Thanks.
Bryan