Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-13 : 22:05:46
|
| Ghanshyam writes "Hi I have made the client server project and client is installed on 10 different system and now when client is started they are picking same record on all system which I don't wanr I want to read different different record on all different system I have also tried with lock type and curser type but it will not effecting my project so I need help in this how to do this with Vb 6.0 and sql server data........" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-14 : 00:53:17
|
| your information sounds that you want to randomly select recordsUse thisSelect columns from yourTable order by newid()If this is not your requirement, give more informationMadhivananFailing to plan is Planning to fail |
 |
|
|
t1g312
Posting Yak Master
148 Posts |
Posted - 2005-06-14 : 03:02:41
|
| I am not quite sure if I understand your question, but here's my solution anyway. You could have an extra field in the table which you can flag whenever the row is retrieved so that the same won't be picked up by another user.Adi-------------------------/me sux @sql server |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-06-14 : 04:53:58
|
i see two possible options for what you want:1. you want to split data based on the client. to do this you must have a column client_id and each client has it's own id.that way you can simply do :select * from MyTable where client_id = 'yourClientId'2. you want all clients to see same data but if one is modifying a row, you don't want others to modify it at the same time.t1g312 has a point with flags...Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
Retrive more than one data to sql server using vb6.0