Hi !!
I have a problem with locks in the database. I have a PowerBuilder
application with
40-50 users logged on at the same time. PB 5.0, Win 95 and Sybase 11.01.
The situation occur randomly, but I think it have to be a bug in my
transaction handling towards Sybase. It often occur when many users are
logged on the database.
I set AutoCommit to FALSE
When I do some updates in the database I do it on the following way:
dw_data.Update()
INSERT .... using SQLCA;
UPDATE .... using SQLCA;
COMMIT using SQLCA;
Is this the right way to do it?
It is not any problem to provoke the situation: If I forget the COMMIT the
application will lock the table. But even if I don't forget the COMMIT I
still have the problem that the application locks a table some times.
Kjell Pettersen