hi, this are the details as requested;
version - 8.5
engine - server
interface - odbc
i am processing the transaction in a stored procedure

could you give me the advantages and disadvantages of locking the whole table or records within the table, but in this particular case i wish i could lock the whole statement.mkd from other workstation access.

i would be most grateful if you could give a code example or site to check for examples

thanks