Hi,

> I am getting a lock no wait Conflict.
>
> I know I am supposed to Use a Transaction.
>
> The line of code I want to use is.
> SET TRANSACTION WAIT ISOLATION LEVEL READ COMMITTED;
> But I dont know where to put it.
>
> Is it in the SP Straight after the BEGIN?
> Is it just before the End?

In a Stored Procedure - it isn't anywhere. You cannot start/stop
transaction inside procedures - all transactions are controlled by
the client (calling) application.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."