error:connections is busy with results for another command

[levi0118]

I have two table

table1
sales
prod_id,qty

table2
prod
prod_id,prod_name

a uniquery with sql :
select s.prod_id,s.qty,p.prod_name from sales s left outer join prod p on s.prod_id=p.prod_id
after prod_id have been modified,i change the prod_name via a query "select prod_name from prod where prod_id=:prod_id"
if i didn't set cacheupdates to true ,it works fine.or cacheupdates is true, but i don't change the prod_id,it works either.
but if i set cacheupdates to true,and change only one prod_id,the first time update is ok.
and if i change two prod_id,or change any prod_id after updated,it will raise "connections is busy with results for another command"
i don't know why?

[levi0118]

env:
windows 7 sp1
ms sql server 2000 sp4
unidac 4.5.10

[AndreyZ]

Please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com . Also please specify the following:
- the script to create the sales and prod tables;
- the exact version of your IDE.

[levi0118]

i have solved it.
thanks a lot.

[AndreyZ]

It's good to see that you've found a solution. If any other questions come up, please contact us.