what does the lock table option do in the dbsys utility?

Im just wondering because I noticed that when a table is locked, transactions will start but once you commit it causes a locking issue. So just wondering whats its doing different to a transaction. Is it just simply locking the actual file?

Graham,

<< what does the lock table option do in the dbsys utility? >>

It sets a table-wide lock, which is actually just a quick way of locking all records at once.

<< Im just wondering because I noticed that when a table is locked, transactions will start but once you commit it causes a locking issue. So just wondering whats its doing different to a transaction. Is it just simply locking the actual file? >>

It shouldn't, and I just tried it here with DBISAM 4.42 (lock the table, start transaction, update record, commit, unlock), and it works fine.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim

Ok it seems you are correct it does seem to work for the most part but i have a table that when locked is allowing it to still start a transaction with. Very strange. Ill have a look at our source for the DBISAM server.

Oh Tim, sorry so are you saying that if a table is locked you should be able to run a transaction still on it?
scenario is lock table with dbsys and start, commit transaction using client app.

Graham,

<< Oh Tim, sorry so are you saying that if a table is locked you should be able to run a transaction still on it?
scenario is lock table with dbsys and start, commit transaction using client app. >>

Ahh, I didn't know you were trying to do this with two separate applications.  You can still do what you want, but you won't be able to edit any records in the client application because of the lock on the table in DBSYS.  Nor will you be able to start any transactions in DBSYS because the client application has one already started.

Tim Young
Elevate Software
www.elevatesoft.com

ok sorry, thanks Tim

Graham,

<< ok sorry, thanks Tim >>

No need for sorry.

Tim Young
Elevate Software
www.elevatesoft.com