Concurrent access

[Shreya Menon]

Hi all,

I am having a situation like this:
Say client A and client B trying to do a select from table A, I donnot want to display the same results to both the clients. How do I accomplish this ? Can anyone give me a sample ?

Thanks

[Paul Sturrock]

You are selecting the same data, but you want to display different data? Can you explain why you want to do this, because you post doesn't seem to make sense?

[Shreya Menon]

Paul,

For business needs, when multiple clients access the data from one table, different results need to be displayed to the clients. The reaon for this is, we allow clients to have a unique item. Customers can select the item/ should be able to select the item by themselves.

In other way, when client A comes he will be given the first 5 records, lets say. Now these 5 records should be LOCKED for display to the next users.

Hope this is clear.

Thanks

[Paul Sturrock]

Please don't post the same topic in more than one forum. Since you've got more attention here I'm closing this topic.