Problem With Temperory table?

southindian

Dear all,


I had designed a report with Temperory table. Its Working fine. But the problem is when the Users from different
Location executes the report at the same time.(for example: The company has branches in two Location London and Paris.
If Users in Paris and Users in London executes the report at the same time , Data related to London Location is shown in Paris and Data related to Paris Location is Shown in London.)
Why this Problem is coming and how to resolve this? Expecting guidence and sugession?
Earlier there was at table Locking problem , But i have resolved it by activating the property of "TranSactioin Type" to Update.

jwilder

I think we need to see the code. A true temporary table is stored locally on the machine of the user that is running it so for another user to get that information seems impossible. First thing, are you absolutely sure your record variable is temporary = yes?