Hi Helen


Answers to you questions follow...

> Can you please supply:
>
> 1. The SQL for ItemtypeQuery
>

SELECT * FROM pr_ItemTypeAccount(:ItemRef, :RegionRef);

Would you like the SP also ? (it is fairly small)

> 2. The exception code and message that you get when you think you
> have a deadlock
>
>
>


> It is not necessary. Any dataset in a read-only transaction is by
> nature read-only.
>
>

Just being safe :)

>> The query providing data for the parameters is not being edited.
>>
>
> Although there's not enough info here to guess intelligently, have
> you borne in mind that a selectable SP isn't "finished" until it
> stops executing? What that means for your application flow is that
> you must complete one invocation before you make another. So, before
> closing the dataset, you will need to run to EOF.
>

Wow, I did not realise that !

However the SP should only be returning 1 row anyway. I will try the
.Last thing anyway :)


Ta

Rob