Click here to Skip to main content
15,911,142 members

Comments by itman2 (Top 12 by date)

itman2 25-Mar-16 2:28am View    
thanks Beefcake
excuse me if my English isnt very well

about this scenario i should say : these file may chang every second or every 30 second or ... we dont know . but i must read them all every 10 second (for example) and use those content.
you said : 1. Use a directory / file watching mechanism which reports changed/new files ....
but i have no access to server just i can read 200 link like this :
http://www.tsetmc.com/tsev2/data/instinfodata.aspx?i=64358061873294912&c=64
i think this(no1 in your solution) mechanism isnt necessary ! (isnt it?)
itman2 17-Feb-15 14:41pm View    
thanks

but how can i select other printer in network ?
itman2 2-Feb-15 6:22am View    
THANS MR zoltan zorgo

i think for this case i can lock my table ! because the time of update proces is less than 1 second .
can you say how can i lock my table
i write this code :


<pre lang="sql">Begin Transaction
Select * From TableName With(TabLockx)
commit transaction
</pre>

after run ths query my table locked and i canu unlock it again !

how can i lock my table an unlock it again ?
itman2 1-Feb-15 15:34pm View    
tanks
your solution means : sql server can fix problem ! is it right ?
i write this cod for sell_button and every thing must be ok . is it right ?

try
{

1- open connection
2- get amount of pen // amount=3
3- new_amount= sell_amount - old_amount //amount=2-3
4- update amount in database // amount= 1
}
catch
{
message : wrong amount...
}

with this cod when user1 and user2 in same time sell 2 pen , user1 can sell but user2 cant sell and the message show for him ! is it right ?



but this link say another thing : https://msdn.microsoft.com/en-us/library/aa0416cz%28v=vs.110%29.aspx[^]
itman2 1-Feb-15 12:02pm View    
what does it men : The first who commit the transaction wins the race. ?
when the first one connect to database there is 3 pen and he can sale 2 of them and in same time the second user also connected and see 3 pen for sale and can sale 2 pen !

is it true ? what happend exactly in this case can you explain it ?

i cant andrestand it !